Double Criteria for Open Form (1 Viewer)

N

notrino

Registered User.

Local time

Today, 10:06

Joined

Oct 18, 2018

Messages

26

• Oct 23, 2018

• #1

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.

 

Attachments

• double_criteria.zip

  75.7 KB · Views: 110

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 09:06

Joined

Jul 9, 2003

Messages

16,278

• Oct 23, 2018

• #2

I suspect your original database was corrupted. I think I might have fixed the corruption but I don't think I fixed your problem let me know!

 

Attachments

• New Microsoft Access Database.zip

  33.6 KB · Views: 121

N

notrino

Registered User.

Local time

Today, 10:06

Joined

Oct 18, 2018

Messages

26

• Oct 24, 2018

• #3

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

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 09:06

Joined

Feb 19, 2013

Messages

16,604

• Oct 24, 2018

• #4

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

 

Last edited: Oct 24, 2018

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 09:06

Joined

Jul 9, 2003

Messages

16,278

• Oct 24, 2018

• #5

notrino said:

Hello Gizmo,

But you misunderstood me.

Click to expand...

It's not a case of I misunderstood you, it's a case of I can't understand what the hell you are doing! I still don't, but I have come up with a solution..

See attached for one solution using SQL statements.

 

Attachments

• New Microsoft Access Database.zip

  40.4 KB · Views: 111

Last edited: Oct 24, 2018

C

CJ_London

Super Moderator

Staff member

Local time

Today, 09:06

Joined

Feb 19, 2013

Messages

16,604

• Oct 24, 2018

• #6

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

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 09:06

Joined

Jul 9, 2003

Messages

16,278

• Oct 24, 2018

• #7

CJ_London said:

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

Click to expand...

Hi Chris,
Yes, I could see that from the data, but not from the OP's description.

I disconnected the parent/child fields linking the main form & subform, and fed both forms "record sources" as VBA created SQL Statements.

It's not possible to guess the real world use from the example given, which makes it difficult to answer the question.

I don't usually answer questions where the OP doesn't show/explain the real world use, because it indicates to me that there are many unseen "rabbit hole" issues, and/or the OP is trying to solve a typical known, easily solvable problem in their own unorthodox way.

Sent from my SM-G925F using Tapatalk

 

N

notrino

Registered User.

Local time

Today, 10:06

Joined

Oct 18, 2018

Messages

26

• Oct 26, 2018

• #8

Hello Gizmo,

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

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 09:06

Joined

Jul 9, 2003

Messages

16,278

• Oct 26, 2018

• #9

notrino said:

It's a pretty complicated

Click to expand...

It may appear so, but its basically a set of common steps. If you know the steps, then you can apply them throughout your code.

In my experience there's usually 3 ways to do something, sometimes more so I'm surprised that no one has shown a different way of doing it. I'd be very interested to see alternatives.

If you're interested in learning how to code in VBA I'm always looking for students. There would be no charge for this, because I am in the process of learning how to teach, which is a different skill to writing MS Access code. I need willing "guinea pigs" to practice on!


Sent from my SM-G925F using Tapatalk

 

N

notrino

Registered User.

Local time

Today, 10:06

Joined

Oct 18, 2018

Messages

26

• Oct 26, 2018

• #10

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.

Code:Copy to clipboard

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

 

N

notrino

Registered User.

Local time

Today, 10:06

Joined

Oct 18, 2018

Messages

26

• Oct 28, 2018

• #11

Uncle Gizmo said:

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


Sent from my SM-G925F using Tapatalk

Click to expand...

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