Form to Form link

[SusanC]

Hi,
I have a look around the site but can't find anything that either helps me or that if it does I don't understand it!!! Any advice would be great!

I have a continuous form and as I have found out have had to use conditional formating to hightlight buttons (unbound controls) to appear depending on whether a control in each record meets criteria.

What I would like now is to click on the button that opens up another form which relates to a control on the main continous form.

For example

Form Name : Stock
Experiment No
1 Washed Highlighted button
2 Not Washed No button

If I were to click on the highlighted button then a form would appear showing be all the information I need for Experiment No = 1.

Is this possible?
thanks
Sue

 

[SusanC]

Hi,
thanks for the reply. I'm not using buttons, just an unbound box that changes colour, so I thought I could use the on click event to get it to open the form with the correct record.
It is this part I'm having difficulty with. I tried using a Macro with a condition but can't get it to work.
Not really sure where to go from here!
Sue

 

[SusanC]

Hi,
i've given it a go but it says I can't opened an operand without an operator!

what do the commas do exactly?
thanks
Sue