Form that performs a querie, newbie question?

[Stiz]

Hi all,

I want to make a form that performs a querie on a table accordinge to a specifc criteria.

Say all the values and info are in "table1" and the criteria is a number must be entered "cust_no" and I want the querie to return the value of "income" that is related to the cust_nom.

This is for internal office use, so their is no online stuff going on, I dont need any html pages that connect to a DB just a form with Access (am I making sense)

anyway any help is greatly appreciated.
Thank you

 

[67peshawar294]

Hi, Stiz
Design a query and in the criteria of the "cust_no" place:
Like [Enter Customer Number.]
Design your form, based on the query making the record source for the form the query name.
When the form opens a "Enter Paramater Value" box will open, enter a customer Num. or part of num and an * and the info will display in the form.
Depending on how you want it displayed, you will have to change the display options either single or continuous.
Jim

 

[Stiz]

Excellent! Thank you.