refresh a combo box

  • Thread starter Thread starter MKM
  • Start date Start date
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
 
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
 
Back
Top