Entering Data into Textbox as Search Criteria

[Moonman]

I have a simple form with four fields, one of which being "WO." I would like the user to input a given 6 digit number (search: any part of field) and click a button, and the remaining 3 fields would be populated with the associated record data. If the 6 digit number does not exist or the textbox is blank, I would like an msgbox to indicate so. I would like to understand how this done in vba to get me away from using the standard find/search dialog boxes and provide me more flexibility as a programmer. I have searched the threads, but as a novice, most threads seemed beyond my understanding. Any help would be greatly appreciated.



Thanks so much,

Moonman

[June7]

Is WO the foreign key and you need to view related info from the lookup table? Options that don't require VBA:

1. include the lookup table in the form RecordSource, bind textboxes to the related info fields and set them as Locked Yes, TabStop No

2. make WO a multi-column combobox, then textboxes refer to columns of the combobox

3. DLookup() in textbox ControlSource expression

Otherwise, if what you want is to input a parameter and filter the form's records, options:

1. parameterized query, review http://datapigtechnologies.com/flash...tomfilter.html

2. VBA to build criteria string and set form Filter and FilterOn properties, review http://allenbrowne.com/ser-62code.html