Searching Data Base

[Guest]

Hello,
I have Access DB, I have tables, one of the tables is cust_details.
The table has fields like: cust_id
cust_name
cust_address
etc.
cust_id is an index , and I want the situation to be; that when I type
customer number in cust_id field, then all the fileds in that form will show
the data of this customer.
I mean that it shouldnt work by clicking on button with name of some
customer, but randomaly typing customer id and get the result in all fields,
like every CRM that can search for customer by typing id

 

[Guest]

Write a query to populate the fields with event On Lost Focus cust_id.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?

 

[Guest]

The Queries forum is probably not the best place to ask this question, but,
this is usually done with a combo box. You use an unbound combo box control
on your form to look up the customer id. You use the After Update event of
the combo box to move to the selected record, and usually use the combo box
Not In List event to offer the user the option of adding a new customer.