Hi,
I am kind of new with Access and I was wandering if someone could help me create a form where I can query data in a table by entering values in that form.
For Example:
I have a table called Customer.
Customer fields are: (PK) CustomerID, CustomerName, CustomerAddr.
I want to be able to create a form that if I enter "1111" for CustomerID, it will bring me back the CustomerName and CustomerAddr associated with that particular CustomerID. So far I have been able to create a query but when I link the query to the form it gives me all the available records... Sample code would be greate...
Thank you in advance
Genti