Double Criteria for Open Form

[notrino]

Hello,

I attached my application,

S1 form showing S1 query values. This form is including double ID (ID1 and ID3) When I push the button, F1 must be open. Same ID1 for F1 is including several ID3 values in the subform. So, I want to ID1 and ID3 criteria at the same time for the main form and subform values. In this way, I can see true records at the same time on the main form. How can I create double criteria? Thanks.

 

[notrino]

Hello Gizmo,

But you misunderstood me. Your solution is including "classic 1 criteria". I want to "2 criteria". F1 form must be open ID1 and ID3 criteria together. Not for only ID1

 

[CJ_London]

for the benefit of responders cross posted here with answers

http://www.accessforums.net/showthread.php?t=74224

@Notrino, You have been advised in the past about this, https://www.access-programmers.co.uk/forums/showthread.php?t=302018, your view was 'don't care'

Edit: apologies - see the other thread you have referenced this one

 

[CJ_London]

I think the OP is saying the subform is not related to the main form

e.g. mainform recordsource - tblRailwayStations, subform recordsource - tblFruit


@notrino - look at using the openargs parameter to pass the id for subform as a value, then some code in the main form current event to apply the id value to filter the subform

 

[notrino]

Hello Gizmo,

Yes your last solution is working. But it's a pretty complicated solution. I scared Thank you again, see you.

 

[notrino]

Hello Gizmo,

Thank you. I created myself solution for this application. If I write this codes for
"buton click event" the program running like yours.

DoCmd.OpenForm "F1", acNormal, , "[ID1]=" & Me.ID1
DoCmd.GoToControl "alt1"
DoCmd.FindRecord Me.ID3

 

[notrino]

. I need willing "guinea pigs" to practice on!


Sent from my SM-G925F using Tapatalk

Of course I'm volunteering. I don't know VBA very well. I am aware that the situation is different, especially in Access applications.