KristenCarr
Programmer
I have very little front-end dev. experience & I'm creating a Call Tracking data entry form. I would like to search by several columns, including LAST_NAME and ID but never more than one column at a time. I have a form and a subform.
What I would like the user to do is open the (blank) form, enter some search criteria (like LAST_NAME), click GO and have the subform populate customer info while the main form remains blank until the user enters specific data. I have the ID column from the subform joined w/ID in the main form since they are pulling from 2 different tables.
I have created queries that I can get to run using a button (then '[Enter Last Name]' pop-up boxes) which return a result set but I need to be able to click or something on the customer I want to select and populate the fields in the subform.
Any help would be appreciated! Thanks.
What I would like the user to do is open the (blank) form, enter some search criteria (like LAST_NAME), click GO and have the subform populate customer info while the main form remains blank until the user enters specific data. I have the ID column from the subform joined w/ID in the main form since they are pulling from 2 different tables.
I have created queries that I can get to run using a button (then '[Enter Last Name]' pop-up boxes) which return a result set but I need to be able to click or something on the customer I want to select and populate the fields in the subform.
Any help would be appreciated! Thanks.
