Open a form based on meeting two criteria ID

[shery1995]

Hi All

I am trying to open a form with following code:

DoCmd.OpenForm "frmClientMatter" ,,,"[ClientID]=" & Me. ClientID &"'"& and "[MatterID]=" & Me.MatterID

But code does not work.

Any help suggestion will be much appreciated.

A Munir

Please note both (ClientID and MatterID) are numeric fields.

 

[plog]

If they are both numeric, there's no need for a single quote. Even if they aren't, quotes need to work in pairs.

 

[theDBguy]

Hi. Try it this way:

DoCmd.OpenForm "frmClientMatter", , ,"[ClientID]=" & Me. ClientID &" and [MatterID]=" & Me.MatterID

Edit: Oops, too slow...

 

[shery1995]

Hi. Try it this way:

DoCmd.OpenForm "frmClientMatter", , ,"[ClientID]=" & Me. ClientID &" and [MatterID]=" & Me.MatterID

Edit: Oops, too slow...

Thank you so much it works fine.

 

[theDBguy]

Thank you so much it works fine.

You're welcome. @plog and I were happy to assist. Good luck with your project.