Open Form – Where condition – multi criteria (1 Viewer)

[MichalB]

Hi All,

Apologies if I overlooked answer to my question in other threads.
How from one form open other form for specific records, I know there is a simple way (Access 2010) to use macro wizard but this works only for if I use one criteria (where condition) ID=ID, Name=Name etc, but how I can use two conditions ID=ID and Name=Name???

 

[Artair]

If you want to use more than one criteria, you simply write it like "[ID]=1 And [Name]='Joe Bloggs'"

If you want to refer to fields on the form, use something like "[ID]=" & Me.ID & " And [Name]='" & Me.Name & "'"

 

[MichalB]

It works now. Thanks!