Text box entry that returns query from entry...hmmmm.

[seanburns76]

Hello all,

I have a project for work that requires a simplistic interface for analysts to create, view, and update records. I am looking for a way to search for records specific to one field value. I want a simple form that has a hand full of text boxes that can return the entire record for that value.

for example: I have a record that contains about 30 fields with varying data(date, alpahnumeric, etc...)..I would love a form that allows me to have a text box where I search by, say..the customer # field for a specific customer #....

I am a complete novice and am having a BLAST learning Access and SQL, but don't have a great deal of time to learn and complete this task. I know the solution is simple, but I'm just not there.



I appreciate all advice and hope to be more of a regular on this site..cheers!!!

[rpeare]

create a form with unbound text boxes or combo boxes.
Name those for the items you want to search for instance:

Item_Date_Search
Model_Number_Search
Customer_Search

Let's say you have a table that lists your customers, You can create an unbound combo box where the customerID is the bound column but the customer number is included, set the first column width of the combo box to 0 the second wide enough that it shows the customer name.

Then base the form on a query of your data table and in the CUSTOMERID field put the criteria [forms]![yourformname]![customer_search]

Then you can update your search either on the ON EXIT of the CUSTOMER_SEARCH field of your form or do something like create a button that performs a requery based on the items selected/typed in.

for an alphanumeric field that does not have limited scope you could use

like "*" & forms!yourformname!model_number_search & "*"

so let's say you have models

HLX-001
HLF-001
MLF-001

if you typed in HL with the criteria the way I've listed you'll find the first two records
if you typed in LF with the criteria the way I've listed you'll find the last two records
and of course if you typed in 001 you'd find all 3

So in short, make your data entry form based on a query that is tied to what your users choose from some unbound combo/text boxes.

[seanburns76]

Wow...Ok...I'll give this a try and get back to ya..I really appreciate it!