Open Form Actiom

roley

Registered User.
Local time
Today, 03:25
Joined
May 28, 2003
Messages
20
Good Morning,

I created a command button and trying to write an on click command. I created a macro to open a form. I want to open this form and to filter all records where the fields are =. In the where condition i used expression builder and put [CUST NAME]=[Rental Form]![customer]. I tried it several ways to no avail. Cust Name is in the main form and customer is in the form I'm trying to open and filter. What am I doing wrong?
 
Create a query with the fields you require on the form then the field that you want to filter , put the "=" or whatever you want to filter in the criteria section of the query then create the form based on the query.

This will show you the records with the filtered results.
There might be other ways at doing this, but this is what I do when I want to filter records and show them in a form.

HTH
Andy
 
The button wizard will create the code for you
 

Users who are viewing this thread

Back
Top Bottom