Hello,
Let me first apologize if any of this is unclear. I have a pretty simple database that employees use to log customer phone calls. For example, after they finish a customer phone call, they open the database, which opens directly to a welcome form, they then click their icon, which is simply a command button that opens their individual form.
The information on the form is employee name, customer name, type of phone call (i.e complaint, dispute, etc.), date of the phone call, time of the phone call, etc. I created a search form the managers can use to search the log of calls. The form is just a blank form with a subform that lists all the call data.
My goal would be to create an advanced search form, but my Access knowledge is very limited. Basically I just want to set up a few combo-boxes and use those to filter the results. For example, I have a combo-box for employee name and selecting “John Smith” will display all calls logged by John Smith. Is it possible to do this? or does anyone have a better idea, that wouldn’t be too difficult?
I’m not too familiar with VBA code and what not, I mostly used the Wizards to see the entire database up. Thank you in advance for an advice.
Thanks,
Chris.
Let me first apologize if any of this is unclear. I have a pretty simple database that employees use to log customer phone calls. For example, after they finish a customer phone call, they open the database, which opens directly to a welcome form, they then click their icon, which is simply a command button that opens their individual form.
The information on the form is employee name, customer name, type of phone call (i.e complaint, dispute, etc.), date of the phone call, time of the phone call, etc. I created a search form the managers can use to search the log of calls. The form is just a blank form with a subform that lists all the call data.
My goal would be to create an advanced search form, but my Access knowledge is very limited. Basically I just want to set up a few combo-boxes and use those to filter the results. For example, I have a combo-box for employee name and selecting “John Smith” will display all calls logged by John Smith. Is it possible to do this? or does anyone have a better idea, that wouldn’t be too difficult?
I’m not too familiar with VBA code and what not, I mostly used the Wizards to see the entire database up. Thank you in advance for an advice.
Thanks,
Chris.
