Searching through a TextBox

[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]

Is all of the data in the Record Source to which the form is bound? If so then create a ComboBox with the wizard that can "find a record...". Look in the AfterUpdate event of this ComboBox and put similar code in the AfterUpdate event of the TextBox. I assume you have your "does it exist" code in the BeforeUpdate event of that control.