Query Lookup

[wwwscott]

Hi all,

Trying to create a query to get data from a table, but I want the criteria to to use data that is currently in one of the fields.

"Faults reported" is the record
"Fault number" is one of the fields.

I want the query to look at the current record it is on (eg : fault number 23) and bring back all the info for that fault number.

broken down :-

I have a form is called 'Faults'
I am on fault number 23 which has loads of other info on it such as fault number, fault type, fault location, fault reported by, etc, etc

I want to have a button on my form which when clicked will print the data for that particular fault number (report form which I will create the look of).

So clicking the button will print off a report with all the info the record I am currently on. If I clicked file and print it would just print off all 3000 faults in the format shown on the screen.

Hope this makes sense. Thanks for any help

Scott

[MMcCarthy]

Hi all,

Trying to create a query to get data from a table, but I want the criteria to to use data that is currently in one of the fields.

"Faults reported" is the record
"Fault number" is one of the fields.

I want the query to look at the current record it is on (eg : fault number 23) and bring back all the info for that fault number.

broken down :-

I have a form is called 'Faults'
I am on fault number 23 which has loads of other info on it such as fault number, fault type, fault location, fault reported by, etc, etc

I want to have a button on my form which when clicked will print the data for that particular fault number (report form which I will create the look of).

So clicking the button will print off a report with all the info the record I am currently on. If I clicked file and print it would just print off all 3000 faults in the format shown on the screen.

Hope this makes sense. Thanks for any help

Scott

Assuming "Faults reported" is the name of the table.

SELECT * FROM [Faults reported]
WHERE [Fault number]=[Forms]![Faults]![Fault number];
 

Mary