synchronize Combobox when navigate thru records

  • Thread starter Thread starter Rusty User
  • Start date Start date
R

Rusty User

Hi. I'm using Access 2007. I have a form where I don't allow New Records to
be added. It's only for editing or deleting records. I have a combobox
where the user chooses the record they want to view.

The user is also allowed to navigate thru records by using Access'
navigation buttons at the bottom of the form. When they do that, how do I
make the combobox show the same value of the form (or the combobox could even
just be blank)?

Thanks for your help.
 
Thanks anyway, everyone. I got it. I changed ComboBox.value = "" in the
combobox lost focus event. First I had to change the combobox recordsource
query to a union query to get a blank value in the list:
SELECT field1 FROM table UNION SELECT "" FROM table
 
Back
Top