Hi everyone,
I have a database currently in use.
I want to create a query (from which I can create a report) to show me data relating one specific record, when run via a command button from the form where the selected record is active.
Basically, I have a form, where each record relates to one item of equipment. I have subdatasheets within the form displaying data about the item in question (all linked via a reference number).
I want to run a query from a command button that selects ONLY the data relating to this specific record and all the linked data. The query is in place, but I am having trouble figuring out how to view the data relating ONLY to the current record being viewed.
I hope that made sense.
Ged.
I have a database currently in use.
I want to create a query (from which I can create a report) to show me data relating one specific record, when run via a command button from the form where the selected record is active.
Basically, I have a form, where each record relates to one item of equipment. I have subdatasheets within the form displaying data about the item in question (all linked via a reference number).
I want to run a query from a command button that selects ONLY the data relating to this specific record and all the linked data. The query is in place, but I am having trouble figuring out how to view the data relating ONLY to the current record being viewed.
I hope that made sense.
Ged.