Prev: Exporting Reports through E-mail
Next: Find out what fields have been changed
From: Confused Esther on 27 Jun 2008 01:32
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!!!
From: Confused Esther on 27 Jun 2008 01:46
Don't worry! Got it fixed! YAY!!

"Confused Esther" wrote:

> 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!!!
 | 
Pages: 1
Prev: Exporting Reports through E-mail
Next: Find out what fields have been changed