DoCmd.OpenForm help

[CoffeeGuru]

I am trying to open a form that will display only the rows in my table where two conditions are met

1 is Country Code [CountryCode]
2 is Retail Chain [Chain]

Theses are both stored on the same form I am trying to run the VBA from
so I hoped that my VBA statement would look like this....but it doesnt

DoCmd.OpenForm "frmWWLiveTbl", , , "Chain=" & [Forms]![MainMenu Country]![cboChain]

I am also unsure how to add the second Where Condition

Can anyone help me

Martin

 

[EternalMyrtle]

So, you are opening the new form from the current form? Try this:

DoCmd.OpenForm "frmWWLiveTbl", , , "Chain=" &Me.cboChain

Make sure that cboChain is the correct control name.

 

[EternalMyrtle]

Is "Chain" an ID field??

Sorry should be:

[CODE]DoCmd.OpenForm "frmWWLiveTbl", , , "[Chain]=" & Me.cboChain

[/CODE]