Form Subform Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
How would you re-query? Isn't entering the new data in the combobox/textbox
and hitting enterkey requerying? I'd imagine that a command button is the
trick, but how do you do that? And if so how would you remove the "update on
enterkey" type of effect? Any help is greatly appreciated.
 
Back
Top