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.
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.