VBA Code not running

abidshahzad4u

Registered User.
Local time
Today, 10:58
Joined
Aug 17, 2009
Messages
15
Hi

I am using Access 2007 and created a database in Access 2003 format. I have to create a report based on form input, obviously based on some query. I have created a form for test and added some VBA code to open query. But it is not functioning. The criteria is provided in the Query Design view at the Criteria Row and referenced to the Form input fields.

Can some one help me in this matter.
 
The report is based on a query but you don't need to open the query separately.
Just enter the query name in the Record Source property of the form.

Also did you remember to enable the vba in the Security Warning when the database was opened?
 
Hi

I am using Access 2007 and created a database in Access 2003 format. I have to create a report based on form input, obviously based on some query. I have created a form for test and added some VBA code to open query. But it is not functioning. The criteria is provided in the Query Design view at the Criteria Row and referenced to the Form input fields.

Can some one help me in this matter.

A visual on what Galaxiom said.
 

Users who are viewing this thread

Back
Top Bottom