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
 
You must log in or register to reply here.

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

Counting multiple memberships 1
Lookups - how to obtain data from a master spreadsheet into another 5
News 419m phone numbers leaked in Facebook data breach 3
Form for Parts-Tools Lists 0
Combobox Weird Behaviour 1
Removing choices from combobox query but stilling showing for older entries 5
Subform not refreshing in Access 97 3
Refreshing combobox criteria 1

Back
Top