W
wolfcw1
Guest
OK,
I have created a form which uses a combo box to lookup a name and then autopopulate the id, name, address, city, state, and zip fields. The id field is populated from one table and the rest from a linked table with id being the linked field. The problem is that when you use the combo box to update the form with another record, Access changes the id field of the first record on the table to that of the second record. Any help is greatly appreciated.
I have created a form which uses a combo box to lookup a name and then autopopulate the id, name, address, city, state, and zip fields. The id field is populated from one table and the rest from a linked table with id being the linked field. The problem is that when you use the combo box to update the form with another record, Access changes the id field of the first record on the table to that of the second record. Any help is greatly appreciated.
