J
jackle
Form Subform Problem
I am having difficulty synchronizing my forms and datasheet subforms that I
use as a lookup (I do not want any changes or updates in this layout!). I
have a text box that I input a part number that feeds info to a select query.
Then I have a datasubsheet that picks up that data. That works good. But when
I input another number it holds and changes the first line in the
datasubsheet from the previously input part number. It continues to hold and
change that line on subsequent inputs while showing the other correct info
for that part number. It's really a mess. I have to exit this form/Subform
after every lookup. Then I re-enter it. Right now I have a popup form from
the query to help. Is there a way to empty out the form upon entering a new
number or exiting this form so I can see a blank form when I re-enter this?
Can anyone please help?
I am having difficulty synchronizing my forms and datasheet subforms that I
use as a lookup (I do not want any changes or updates in this layout!). I
have a text box that I input a part number that feeds info to a select query.
Then I have a datasubsheet that picks up that data. That works good. But when
I input another number it holds and changes the first line in the
datasubsheet from the previously input part number. It continues to hold and
change that line on subsequent inputs while showing the other correct info
for that part number. It's really a mess. I have to exit this form/Subform
after every lookup. Then I re-enter it. Right now I have a popup form from
the query to help. Is there a way to empty out the form upon entering a new
number or exiting this form so I can see a blank form when I re-enter this?
Can anyone please help?