DoCmd.OpenForm ---- I don't know how to make my filter work

[dk4300]

Hi!
This is one of those things that people either can do really easily or have no idea. I'm in the no idea catagory.

In a super-simplified example:
Form1 has a field "Customer". I want a button that will open Form2 and filter the records where Form2 "Customer" is the same.

The part in bold is the problem. I don't know if I tried it this way (I usually have something in quotes), but every single thing I've tried pulls up all the records or none of the records. Could someone please tell me what should go in the bold section?

Thanks a ton!!!


Dim strCustomer as string

strCustomer = Me.Customer

DoCmd.OpenForm "Form2", acNormal, Form2.Customer = strCustomer

[ADezii]

Hi!
This is one of those things that people either can do really easily or have no idea. I'm in the no idea catagory.

In a super-simplified example:
Form1 has a field "Customer". I want a button that will open Form2 and filter the records where Form2 "Customer" is the same.

The part in bold is the problem. I don't know if I tried it this way (I usually have something in quotes), but every single thing I've tried pulls up all the records or none of the records. Could someone please tell me what should go in the bold section?

Thanks a ton!!!

Dim strCustomer as string

strCustomer = Me.Customer

DoCmd.OpenForm "Form2", acNormal, Form2.Customer = strCustomer

DoCmd.OpenForm "Form2", acNormal, ,"[Customer] = '" & strCustomer & "'"

[dk4300]

DoCmd.OpenForm "Form2", acNormal, ,"[Customer] = '" & strCustomer & "'"

Thank you so much! I totally get it now, an just finished updating my forms w/ all sorts of filter conditions.
Just what I needed.
Thanks!

[ADezii]

Thank you so much! I totally get it now, an just finished updating my forms w/ all sorts of filter conditions.
Just what I needed.
Thanks!

You are quite welcome.