Requery

  • Thread starter Thread starter Sheila D
  • Start date Start date
S

Sheila D

I've read lots of post on requery but still can't get my combo box to update
without closing the form to force the refresh. I have a form with a combo box
in which the user can add multiple entries some of which can be duplicated so
all I want is for a new entry to automatically be added to the drop down list
.. If someone could please tell me what the code should be and which event I
should place it on I would be most grateful. Thanks for any help
Sheila
 
Thank you Mark but could you please tell me exactly how I should write the
code and which event I need to place it on - I don't know much about VB (as
you can probably tell)
 
Thanks Mark, I tried that but it comes up with Run time error 438 Object
doesn't support this property or method, it does not like
Me!nameOfYourCombobox.Refresh

any othe suggestions....
 
Ah, got it to work by putting Docmd.Requery "Fieldname"

Thanks for pointing me in the right direction
 
Back
Top