refresh a combo box

M

MKM

I have a combo box in the form header that finds my record of interest (I
used the wizard to create it.) When I disapprove a client (in the
after_update event of a frame that contains option buttons labeled "approve"
and "disapprove") that record disappears (via Requery in the same
after_update event) and shows the next in the list; however, the combo box
still shows that name. If I choose any other name it does disppear, but I
would like to combo box to move to the next client at the same the detail
section show the next record.

thanks,
MKM
PS I wrote it in Access 2003 but am currently using 2007
 
M

MKM

excellent. And, as I actually wanted to show the client's name, I was able
to substitute me.TableID for me.FirstName

thanks for the help!
MKM
 

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

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Word OLE to check spelling in text box 1
Issue Refreshing/Requery Subform/combo box 1
Refresh the data in dropdown combo box 7
How to return the primary key from a combo box 5
Access Combo Box Refresh 1

Top