Print Current record

[Dave Richardson]

Hi everyone,

I recieved an excellent reply to a problem I had in syncing a record to a report which was based on the value in a combo box. This has worked a treat, but I came unstuck last week when a duplicate entry appeared in the second field on the form the report is synched to. The database is for courses whereby each course run has an entry (which increments after each course). The combo box on the form is populated with the courses (which don't change naturally) which are run (i.e. CN1895, CN1897 etc..) The number of courses run throughout the year is called the Course Entry (Me.CrseEntry).

The following code works really well for synching with the combo box from the report:

DoCmd.OpenReport "RptNominalRole2", acPrintPreview, , "CourseNo = '" & Me.CourseNo & "'"

What I need to be able to do is synch the report to both the combo box and the control for course 'Entry'.(Me.CrseEntry). This will prevent the mismatch with an older record in the database which will be against a different course.

Thank you for your assistance

Dave

[Dave Richardson]

Hi again, I have tried the 'and' operator between the expressions and all ok when I debug. But get a 'type mismatch' when i run the report. This is more than likely down to the controls being different? i.e. one is a combo box and the other a TxtBox. Here's how it looks in the editor.

DoCmd.OpenReport "RptNominalRole2", acPrintPreview, , "CourseNo = '" & Me.CourseNo & "'" And "CrseEntry = '" & Me.CrseEntry & "'"


It would really be appreciated if a way could be found to get this to work, or there is another way around this.

Many thanks

Dave