selecting a rpt from a cbx and a ck bx

[Dgavilanes]

Hi all.
I have a combo box ( cbxCode) with 8 rpt names Example ( Pending Affidavit, Affidavit approved etc).
Within the form(A continous form) I have a ck box (CKFlag) which is selected for flaging current record for printing.
I would like to add a cmd button that once a rpt is selected from within the cbx and a ck box is present (V) it would select the rpt ( Via Query).

Any help would be appreciated

thanks

Dennis

 

[WayneRyan]

Dennis,

If you are wanting to print the current record, your table has a
field called RecordID and you have a control on your form called
SomeID, then this can be the code for the AfterUpdate event of
your CheckBox.

If Me.CheckBox Then
  DoCmd.OpenReport Me.cbxCode,,,"[RecordID] = ",Me.SomeID
End If

Wayne

 

[Dgavilanes]

Thanks Wayne makes sense, now how about being able to select a rpt from the cbx ?

have a nice day

Dennis

 

[WayneRyan]

Dennis,

That's what it does ... that's the first agument.

Wayne

 

[Dgavilanes]

I needed a wake up call

Thanks

Dennis