Hi there, I'm sure this is a stupid question but here goes.
I have a form that contains bound textboxes to a table in the db. What I want to be able to do is to have a combobox which I use to select the customers name, have it fill the textboxes with the right info so that I can edit the details. The problem I am having is that whenever I select a value from the combobox, it populates the fields with the right data but as soon as the combobox loses focus, the textboxes display the data from the next record. I havent coded anything in VBA, I have just used the wizard.
Am I missing something obvious? I am using Access 2007
Thanks in advance
I have a form that contains bound textboxes to a table in the db. What I want to be able to do is to have a combobox which I use to select the customers name, have it fill the textboxes with the right info so that I can edit the details. The problem I am having is that whenever I select a value from the combobox, it populates the fields with the right data but as soon as the combobox loses focus, the textboxes display the data from the next record. I havent coded anything in VBA, I have just used the wizard.
Am I missing something obvious? I am using Access 2007
Thanks in advance