creating a query

[GazzaG]

Help please
I have a table TblFireSafetyInspection and within that a field called ReportID, i would like to create a button on a form that when the user clicks on it it will ask them to select the ReportID and that particular report will open with the information, what do I need to put on the query to make this happen

thank you

 

[Crowley16]

presumably your reportid is unique in table?

then in your query, you would need to put something like:

SELECT * FROM tblName WHERE reportid = "reference to reportid selected"

the reference to reportid can either be a control on a form where you put the report id once a user selects it, or a string that's been filled with the reportid when you click on the command button

 

[GazzaG]

Thanks crowley but i just put [which report ID] and that did the trick i was looking for.

thanks again