Refreshing Data-HELP~

  • Thread starter Thread starter DBarker
  • Start date Start date
D

DBarker

I have one form that is based on a query, now when
something is not in the list it automatically opens the
form to add the item. But when you are done that and go
back to the initial form the item you just added to the
table does not show up in the list. I have tried
refreshing and updating. I know there has to be an
easier way to do this.

PLEEZE HELP! Been working on for two days and have asked
several people that know access. I have Access 97
version.
..
 
Hi D

In the after-update event of the combo box(at least that's
what it sounds like from your description) put the
following code:
Me.requery
That should do the trick

HOPE THIS HELPS
 
No this did not help! When it leaves the initial form
that form is still open in the background because if you
close this form it will not accept because the vendor was
not added and this is a required field. I tried changing
the tab order so that it would not assign an auto number
for the ID so that I don't have multiple IDs with no
records and I could close the form and come back in but
when the form loses focus and you come back to it it
assigns the number.
 
Back
Top