Thanks as always for your help. This should work just fine for my puposes. The combobox.requery is something I don't remember seeing yet, just the refresh and requery forms which I have used a lot. Again thanks for your help.
Reply from Richard Rost:
You can requery the list of items in a combobox or listbox by saying:
Forms!FormName!ComboBoxName.REQUERY
I sometimes create a quick data entry form - like just name and email or whatever essential items you need. You can even make that a MODAL, POPUP window so the user HAS to type in data or cancel it. Then, in that little form's ONCLOSE event run your REQUERY event for the combo box.
Works like a champ. You know what... I'm just getting ready to record Access lessons for today, so I'll take a few minutes and make this into a short TIP video for you. Give me a couple hours. :)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 324.