Please check my code

Leong

Registered User.
Local time
Today, 15:11
Joined
Jan 10, 2007
Messages
21
I have 3 queries and use 3 different forms as search criteria.

The forms produce a query or a report based on the selection in combo box. (please see attachment)

The query button works 100% of the time yet the report button although works some times gives the following error messege.

'Runtime error 3326 - This Recordset is not updateable'

yet once i click 'End' on the messege it gives me the correct report.
 

Attachments

  • search form.GIF
    search form.GIF
    66.4 KB · Views: 122
This is the error messege
 

Attachments

  • Run-Time Error.GIF
    Run-Time Error.GIF
    67.9 KB · Views: 126
As you can see the code matches the report name.

So am not sure whats wrong. as it works then it doesnt.

Unless I just need tot turn off the error messege in this case ???
 

Attachments

  • code.GIF
    code.GIF
    72.2 KB · Views: 151

Users who are viewing this thread

Back
Top Bottom