I haven't used access for a while, and I am having a brain freeze.
I have a form that collects data from multiple tables(SQL linked database), the form has (at current) four tabs on it, each tab represents one of the tables, I have built a query that will extract the info that I want, and I have a search screen for users to enter a Client ID (which is the primary key across all the tables).
Upon clicking search I want this to populate my new form with the details from the tables.
I just need to remember (which i can't and i can't seem to find a simple way of doing) how do I pass the Client ID to the query, I am pretty sure that I need to make the main form data source the query, but as I say am now stuck.
If anyone can help (hopefully I have made it clear) I would be very apprecative.
Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing you never — ever, put in a trap. … Me.
I have a form that collects data from multiple tables(SQL linked database), the form has (at current) four tabs on it, each tab represents one of the tables, I have built a query that will extract the info that I want, and I have a search screen for users to enter a Client ID (which is the primary key across all the tables).
Upon clicking search I want this to populate my new form with the details from the tables.
I just need to remember (which i can't and i can't seem to find a simple way of doing) how do I pass the Client ID to the query, I am pretty sure that I need to make the main form data source the query, but as I say am now stuck.
If anyone can help (hopefully I have made it clear) I would be very apprecative.
Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing you never — ever, put in a trap. … Me.
