Need Help Filtering Records on a Form using a Macro

J

J. B.

Hi all,

I have been trying to apply a filter to data set inside Access. When
applying the ApplyFilter Macro to the form I don't get much luck. I start
by opening the forming with the macro and then using the ApplyFilter Macro
to the form and I still recieve the entire record set. I have tried to
create a basic form with a combo box (unbounded) that will list the Customer
Names and store the Cust_ID (Primary Key for the tblCustomer table) in the
combo box. I then added a command button placing the a macro on the On
Click event. In the macro, I open the form using the OpenForm macro and
then I try to use the ApplyFilter macro to the record set based on the
Cust_ID that was captured from the combo box. I have been unsuccessful.
The Cust_ID field is not the primary key field of the form that I am trying
to filter but I was wondering if I could filter the records by using the
Cust_ID field. The primary key field of the form is Problem_ID. The
Cust_ID is a foreign key in the relationship.

Any help would be much appreciated!

Thanks in advance,

J. B.

PS I am able to filter the records using the filter buttons on the toolbar
but I was wanted to be able to filter the records through the form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top