Hi, I have a table called Proyects. This table has an Id, name, and year.
I made a form with the third option of the combobox wizard, for searching a record. So when I select a record throw the combobox, it displays all the info about that record. Until here, everything's ok.
The problem is that when I click on next record (little arrow on the lower section of the Access screen, near the search box), the combo box doesn't select the new record.
Aditional info:
The form has 2 fields selected on Row Source: Id and name
Control source is empty
If I set the name field on control source, the names of the combo box star to change to the id numbers as I select them on the combobox. So after clicking on all the names of my combobox, my combobox displays only id numbers and not names.
If I set the id field on the control source, I can´t select the records on the combobox, due Id is a primary key.
I haven´t found any answer on the Internet
What can I do, please help me.