Access 2010 Beginner 8

Access 2010 Beginner 8
By Richard Rost

10 years ago

Back to Access 2010 Beginner 8

Combo box Upload Images Link
andrew davis
8 years ago

Hi Rich, I set up a database which uses combo boxes. However, instead of setting up the Attribute table with 1 field and then adding the items to this table. I set up the attribute table with several fields (text fields), where each field is a selection in the combo box. I would like to change the table format similar to your format so that I can create a form of the table to allow adding of attributes available in the combo box. I would have to delete this combo field box and exchange it with the new one. Is there a way to do this without losing the data in the other 1800+ records? Thanks Andrew

Reply from Alex Hedley:

Does your Table contain an AutoNumber or is it just a Text value you are storing from the Combo selection?
If it had an AutoNumber which will change you could copy these attributes into your new table then do join from old to new and an UPDATE query to set the old value to the new AutoNumber.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access 2010 Beginner 8 Comments