D
DBarker
Subject: Refreshing Data-HELP~
From: "DBarker" <[email protected]>
Sent: 2/6/2004 4:40:22 PM
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.
From: "DBarker" <[email protected]>
Sent: 2/6/2004 4:40:22 PM
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.
..-----Original Message-----
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
.