I have a form which has a query made up of a few other queries (this may be 
an incorrect thing to d
I've been going nuts trying to figure this out, so any help is 
appreciated!!o) 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 
apprecitated!

Allen Browne has some very good help on that problem at www.allenbrowne.com

"dboollu" wrote:

> I have a form which has a query made up of a few other queries (this may be 
> an incorrect thing to d
> I've been going nuts trying to figure this out, so any help is 
> appreciated!!o) 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 
> apprecitated!
> 

Thank you for your suggestion.  I went to Allen Browne's website looked at 
every one of his microsoft Access Tips.  I was unable to find anything that 
would help me with this issue.  Could you please give me a little more 
guidance as to exactly which tip you were thinking of?  

I am using Access 2003.

Thanks!  

 

"Golfinray" wrote:

> Allen Browne has some very good help on that problem at www.allenbrowne.com
> 
> "dboollu" wrote:
> 
> > I have a form which has a query made up of a few other queries (this may be 
> > an incorrect thing to d
> > I've been going nuts trying to figure this out, so any help is 
> > appreciated!!o) 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 
> > apprecitated!
> >