How to filter a form from an item selected in a combo box.

C

Confused Esther

On my form 'frmReportGenerator' there is a combo box 'cmbGetProjectID' that
looks up the field 'Project ID' from the table 'tblProjects' and a command
button 'cmdPreviewReportMarkers' that opens up 'rpt_Markers'. The report,
based on the query 'qryReportMarkers' brings up all records with all Project
IDs.

I want the report to only bring up the records with the ProjectID that is
selected in the combo box. I know the query and the form need to be bound
somehow. I have looked online at help pages eg.
http://www.access.qbuilt.com/html/forms.html#FilterFormByCbo, but I am not a
developer and not familiar with code. I have tried to follow the
instructions, but I don't really understand, and it's not working.

Can someone explain what I need to do (simply) and any code that I need to
use?? Many thanks!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Text Field is Now Combo Box 2
Form filter with multi-column combo box in report 0
Form filter with multi-column combo box does not work in report 0
Look up tables vs. value fields via combo box on form 2
combo box filter 1
Self-Populating Combo Box 1
Combo Box Filter 1

Top