Recent content by kerrmuir

SOLVED My original code works perfectly for both forms and reports. I had a \ after the first commas which should not be there and also there were spaces in my field and report names which caused the errors, a beginners mistake! The report is opened with a filter on the date sent field. This...

So, what I need to do is print my report from a filtered form. That's what I'm seeing from everything I'v Googled so far and from your advice! Is there any way it can be recorded that the print request was from a report and not from a form????

I have a Y/N field in a table that I want ticked when a report is printed for a record or batch of records. The report filters my record/s for a certain date. The code I have is this but i'm not sure what the WHERE should be exactly as if fails at that point! If MsgBox("Would you like to print...

OK, I can't get this to work. I have a report that when opened asks for a date which filters to print letters for a specific date. It filters records for this date then I print it. I want it to update a Y/N field in the main table to say that this record has been printed. The code above works...