Opening a form based on another form's number

[superrob5]

I have 2 tables and 2 forms. One is called help and one is job.


The helpnumber can be in the jobs but no always.

I have a button on the help form and I want to open all jobs that are associated to that number.

[Log Number]=[Forms]![frmLOGENTRYJD]![Log Number]

but it doesn't work.

 

[ColinEssex]

I have a button on the help form and I want to open all jobs that are associated to that number.

What do you mean by "open"?

a list box or subform listing perhaps?

Can you be a bit more specific please

Col