Searching through a text box

[viperstingray]

Hi All,

I have a small yet important question to ask. I have a text box on a form, that text box accepts a product number that the user wants to modify. I want to be able to do the following:

- If the product number does not exist, prompt with an error message (this part is not a problem).
- If the product number does exist, populate the text boxes on the form with the respective data. ex: Product number 512547. Does exist, hence: (TB = textbox)
Prd. No.TB = 512547
Rec'd Date.TB = 10/10/2006
Comments.TB= blah blah blah, etc.
I am simply trying to pull information from a table into text boxes on a form using a text box.

THANKS A MILLION!

 

[RuralGuy]

Please do not multi-post your issue: The post in the General Forum

 

[normski]

Well, what I did, I wish i had the database on this pc, is I used ac ombo box in the header and made it so that when I clicked on a certain patient record (a doctors office) the main body of the form brought up all the data in the correct boxes. Would that suffice?