capturing input from a prompt

[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

 

[Marshall Barton]

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.

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

 

[Tony]

Excellent this worked out great. Have a great day I know
I will.

Tony

-----Original Message-----

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.

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