Opening a Form from another record

[robrien]

I have followed an online tutorial to open a form from clicking on a record.



My form is a weekly schedule that has job tasks in a subform. Using the OpenForm macro I have set it to open the job details form when you double click on the job number in the subform. I have set the where clause to the job number on the job details form.

The macro opens the job details form but the filter does not work and returns a blank form (ie no record).

Could someone please supply some suggestions on what may be causing the filter problem.

[Ruegen]

Tip. Make a button on the subform record then go through the wizard. It will make the perfect macro if you follow the wizard correctly and find it works.

To get that macro, open the button onclick event once it is created, copy the macro (right click or click and control copy it) and then paste that macro into anything you want to do the same thing when you click on (i.e. your job number).

Delete the button once done.

[RuralGuy]

Is the Job Number a string value or a number? Strings require quote 'delimiters'.