Requery

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
 
S

Sheila D

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)
 
S

Sheila D

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....
 
S

Sheila D

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

Thanks for pointing me in the right direction
 
Top