capturing input from a prompt

  • Thread starter Thread starter Tonyony
  • Start date Start date
T

Tonyony

I have a small access 2000 db that I am entering a phone
number into to look up a name. If the name does not exist
I loose the phone number I entered. How can I capture the
entered parameter and populate a text box on my form. Any
help would be greatly appreciated.

Thanks

Tony
 
Tonyony said:
I have a small access 2000 db that I am entering a phone
number into to look up a name. If the name does not exist
I loose the phone number I entered. How can I capture the
entered parameter and populate a text box on my form. Any
help would be greatly appreciated.
Click to expand...


Use an unbound text box on the form to enter the number.
Then change the query to use the text box instead of a pop
up prompt. Just cange the criteria in the query from [Enter
Phone No.] to Forms!thenformname.thetexxtboxname
 
Excellent this worked out great. Have a great day I know
I will.

Tony
-----Original Message-----
Tonyony said:
I have a small access 2000 db that I am entering a phone
number into to look up a name. If the name does not exist
I loose the phone number I entered. How can I capture the
entered parameter and populate a text box on my form. Any
help would be greatly appreciated.
Click to expand...


Use an unbound text box on the form to enter the number.
Then change the query to use the text box instead of a pop
up prompt. Just cange the criteria in the query from [Enter
Phone No.] to Forms!thenformname.thetexxtboxname
Click to expand...
 
Back
Top