user input criteira

[rival]

Ok im real sorry to ask this, i know i have seen the answer before but right now i am really struggling to find it or work it out :S

simple question -

report results dependant on user input. From what i can think i would like to make a form appear i.e. 'customer selection' prior to the report being run. From this i would select the 'Customer' for example, and only that customers specific details would show up.

I know there is a simple answerto this, but right now... its evading me, sorry again and thx for help

 

[Rickster57]

Report

Create a query that uses the table of interest(say customers table which contains customername and address). Create a report that uses this query.

In the query under customername (in the criteria field)place the name of the text box on the form the user is enter data or choosing data. For instance, if the text box on the form is text0 (form is called FrmForm1) enter into the criteria field under customername forms![FrmForm1].[text0]. This way the report will only show the records for the company the user entered (or better yet, chose from a combo box on the form). Have a command button on the form that runs the report when clicked.

Hope this helps

 

[rival]

thanks for the reply. For some reason i am still struggling with this.

What i have done so far is;

./ Created a report based on the tblSupplier, simple select, all info
./ Created a form 'selectasupplier' based on tblSupplier
./ Where the SupplierID field is shown on the report i have replaced the text with Form.selectasupplier.Combo0

but on running it prompts for an input (rather than a combo selection) and even if manually input a correct SupplierID a #Name? value is returned.

Sorry i am having such problem grasping this. I dont seem to have a grasp of the theory side of this

 

[Rickster57]

one step at a time

Let's back up and do one thing at a time.

1)First create a query with the table(s) you need.
2) Run the query and look to see if the data makes sense.
3). If step 2 worked, enter under the criteria field in the query the name of a customer (or whatever) you would like to see data for (For example, "Bill Smith"). When you run the query see if the data for Bill Smith appears.
4). If the above works and makes sense then proceed to the report.

 

[rival]

thanks again.

i can successfully get the report to run the querry with the criteria entered originally e.g. John Smith, and from this only John Smith is displayed on the report.
What i am having problems with is changing this criteria at the report level. Say i wanted to look up Jannet Smith, without having to alter the query. From query level i can manipulate the data as i need but stuggle to give users access to the data only via the report

 

[macca the hacke]

In the criteria field of the query, instead of hard coding in the name 'John Smith', then put in the following:

like [Enter name of customer] & "*"

 

[rival]

thanks alot, this solved my problems

& "" - very useful