D
dboollu
I have a form which has a query made up of a few other queries (this may be
an incorrect thing to do) as the Record Source.
It has a three textboxes on the form in which I need each one to perform a
specific query associated with that textbox. In other words, the user types
in a number, presses 'Enter' or 'Tab' key, then the query (maybe needs
another mechanism) associated with that entered number will execute, and it
will display the relevant results in the form. This is the reason I used a
query containing the need queries as the form Record Source, so I could bind
each textbox where the results from the executed query will populate.
I have done this with a CustomerName combo box at the top of the form, but
not with a textbox. I can not link this CustomerName to the rest of the
form, because there will be many products (first textbox) etc associated with
this specific customer. And my employer does not want drop downs for these
other values that the user will manually enter.
I have tried using the AfterUpdate, OnExit, OnLostFocus event properties
with no luck. I'm sure one of these is the answer, but I am not getting it.
Also, I am not a great VBA programmer. I have been going nuts trying to
figure this out, so any help is appreciated!
an incorrect thing to do) as the Record Source.
It has a three textboxes on the form in which I need each one to perform a
specific query associated with that textbox. In other words, the user types
in a number, presses 'Enter' or 'Tab' key, then the query (maybe needs
another mechanism) associated with that entered number will execute, and it
will display the relevant results in the form. This is the reason I used a
query containing the need queries as the form Record Source, so I could bind
each textbox where the results from the executed query will populate.
I have done this with a CustomerName combo box at the top of the form, but
not with a textbox. I can not link this CustomerName to the rest of the
form, because there will be many products (first textbox) etc associated with
this specific customer. And my employer does not want drop downs for these
other values that the user will manually enter.
I have tried using the AfterUpdate, OnExit, OnLostFocus event properties
with no luck. I'm sure one of these is the answer, but I am not getting it.
Also, I am not a great VBA programmer. I have been going nuts trying to
figure this out, so any help is appreciated!