Filter data on a continous form via a value from another form (1 Viewer)

M

MattioMatt

Registered User.

Local time

Today, 10:40

Joined

Apr 25, 2017

Messages

99

• Jul 18, 2017

• #1

I currently have two continuous forms. On form_A I'd like to link values in one column so that it will open form_B when the end users clicks on the link and filters the continuous form_B with value of which the end user clicked on from form_A is this at all possible?

 

Ranman256

Well-known member

Local time

Today, 05:40

Joined

Apr 9, 2015

Messages

4,337

• Jul 18, 2017

• #2

open the 2nd form using the key in form A:

docmd.openform "form_B" ,,,"[id]=" & me.id

 

M

MattioMatt

Registered User.

Local time

Today, 10:40

Joined

Apr 25, 2017

Messages

99

• Jul 19, 2017

• #3

Apologies for the delay in replying.

Thanks for your post, it's almost working. At the moment I am getting a pop up to ask me for a value.

Does it need an extra set of quotes? As I hadn't previously mentioned this is for a text field not a numeric field

 

Minty

AWF VIP

Local time

Today, 10:40

Joined

Jul 26, 2013

Messages

10,371

• Jul 19, 2017

• #4

Yes you need to escape the text value;

Code:Copy to clipboard

docmd.openform "form_B" ,,,"[id]=[COLOR="Red"]'[/COLOR]" & me.id & [COLOR="red"]"'"[/COLOR]

 

M

MattioMatt

Registered User.

Local time

Today, 10:40

Joined

Apr 25, 2017

Messages

99

• Jul 20, 2017

• #5

Thanks so much Minty! It works perfectly! Thank you to you both!