Filter data on a continous form via a value from another form

[MattioMatt]

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]

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

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

 

[MattioMatt]

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]

Yes you need to escape the text value;

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

 

[MattioMatt]

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