synchronize Combobox when navigate thru records


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.
 
Ad

Advertisements

R

Rusty User

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top