Hi all,
Extremely new to Access and VBA, I have been working my way through several books and sites, and I'm finally breaking down and crying for help.
I am developing a contacts/messages/engagement/appointment tracking application for the CPA firm that I work for. I have made a main switchboard containing tabs with commands to open detail for records, but it is also important to be able to quickly view summarized data for outstanding engagements, calls and appointments. To do this I've created subforms on the switchboard displaying the pertinent info, I would like to be able to double click on one field (such as their number) and it display all phone calls from that specific client.
I have written a query and edited the onclick event to do this, but it pops up with a dialog box to enter the clientID, I would like to filter the query automatically based on which client I click on. My question is, how can I reference the specific client clicked on in VBA to define the query's criteria?
Does this seem like a decently efficient way to get what I'm asking for?
Thank you to anyone who can shed some light on this.