Double Criteria for Open Form

[notrino]

Hello,

You know, we can open the form with criteria via this code;
(Buton click event);

DoCmd.OpenForm "FormName", acNormal, , "[ID1]=" & Me.ID1

But, if we have 2 pcs. criteria, how can I open that form? For example ID1 for main form, ID2 for subform, so I want to call at the same time ID1 and ID2. How can I change above code? Thanks

Note:https://www.access-programmers.co.uk...d.php?t=302065

[June7]

Try:

DoCmd.OpenForm "Tablo2", acNormal, , "[ID1]=" & Me.ID1 & " AND [ID2]=" & Me.alt1!ID2

[Minty]

How is the data in the subform linked to the main form?
Normally that controls what is displayed in the subform, and therefore you only need to open the relevant main ID ?

[notrino]

Hello June7,

Your solution giving error like this;


Hello Minty,
For example ID1 can be include different ID3 values. Like;
ID1=1 --> ID3=1
ID1=1 --> ID3=2
ID1=1 --> ID3 =3
And
ID3 can be include a lot of different records. For example, I want to see "ID1=1 and ID3=2" records via one click button. I need to double criteria.

[June7]

@Minty, I looked at the db from other thread. Appears OP wants to open a third form that has a RecordSource which includes both tables. But now that I look at it again, you are correct. The fields ID1 and ID2 are PK/FK so they have the same values. Don't need ID2 in the criteria.

Well, where did you use the code you originally posted? The database doesn't have any VBA code.