Refresh Lookup In A Combobox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database for my club, which is limited to 200 members.
To issue a member number I have a query that I use in a combo box look-up
returning un-used numbers.
How can I have the list in the look-up refresh After Update so that if I
select a number it is removed from the list?
Also if I change the number the list then shows the old number but removes
the new number from the list?

Any help appreciated.

Nick
 
Nick,

If I understand you correctly, I think you could use code like this...
DoCmd.RunCommand acCmdSaveRecord
Me.MemberNumber.Requery
 
Back
Top