filter results by combo box

[foxtet]

Hello Guys!

I have placed a combo box in the cargoSearch form header to filter records based on its selection on subform which is placed on the details section of the form.
when I select comobo seclection I get error message 'Run time error 3251'
Can I have this error corrected.

The other issue is that the found record when double clicked I need to open frmCargoMaster. Help to resolve these issues.

Fauzy

 

[arnelgp]

double click on MawbNo on the subform to open Cargo form.

 

[foxtet]

double click on MawbNo on the subform to open Cargo form.

Thank you arnelgp,

It worked as the way I was looking for. In the meantime

1) Can you add reset button next to search combobox so that the sub form will have all records displayed when clicked.

2) A label below the subform displaying number of records.

Good Day!

 

[arnelgp]

here you may try this

 

[foxtet]

here you may try this

Thank you!
Excellent solution!
One lats thing that I look for is that the label displaying total records on sub form can have format like 2 of 50.

 

[arnelgp]

you may try this again

 

[foxtet]

you may try this again

[SOLVED]
Solution is exact and worked fine

Thank you!

 

[foxtet]

Hi arnelgp,

I have added Add New Cargo button on frmCargoSearch. When I add a new record on it and close that form added record is displayed on the subform.

To get that record in sub form every time I have to close the frmCargoSearch and re open it.

Can I have the record displayed in the sub form as I save the new record and close that form.

Here attached is the db copy

Thank you for your time

 

[arnelgp]

again try it.

 

[foxtet]

[SOLVED]
I honor your coding skills and excellent knowledge in access programming. Hope that you will attend to the other threads that I post in this forum

Thank you for your time.

foxtet