open form/subform at specific record

  • Thread starter Thread starter john
  • Start date Start date
J

john

I have a form (repair status) the has the same field (work order #) as
another form which is actually a subform(work order detail) to a main form
(Customer data). What I want to do is double click on the field (work order
#) and have it open the form (customer data)/(work order detail) at that
specific record.

I selected On Dbl Click to run a macro that opens the form where both field
match. That works but it pulls the customer data form and the work order
detail but it goes to the first work order detail associated to that customer
not the specific on i clicked on. Any idea what i'm doing wrong.

This is the condition i'm using in the macro.

[Work Order Number]=[Forms]![Frm Work Order Status]![Qry Open Work
Orders].[Form]![Work Order Number]
 
Instead of condition try adding the following actions --
GoToControl --- [Work Order Number]
FindRecord ---- [Forms]![Frm Work Order Status]![Qry Open Work
Orders].[Form]![Work Order Number]
 
I tried this but the field i'm looking to match and open to is in the
subform. When I try this i get an error stating there is no field call Work
Order Number.

KARL DEWEY said:
Instead of condition try adding the following actions --
GoToControl --- [Work Order Number]
FindRecord ---- [Forms]![Frm Work Order Status]![Qry Open Work
Orders].[Form]![Work Order Number]

--
Build a little, test a little.


john said:
I have a form (repair status) the has the same field (work order #) as
another form which is actually a subform(work order detail) to a main form
(Customer data). What I want to do is double click on the field (work order
#) and have it open the form (customer data)/(work order detail) at that
specific record.

I selected On Dbl Click to run a macro that opens the form where both field
match. That works but it pulls the customer data form and the work order
detail but it goes to the first work order detail associated to that customer
not the specific on i clicked on. Any idea what i'm doing wrong.

This is the condition i'm using in the macro.

[Work Order Number]=[Forms]![Frm Work Order Status]![Qry Open Work
Orders].[Form]![Work Order Number]
Click to expand...
Click to expand...
 
Try telling it to go to subform the same way you reference the subform --
[Forms]![Frm Work Order Status]![Qry Open Work Orders].[Form]![Work Order
Number]

--
Build a little, test a little.


john said:
I tried this but the field i'm looking to match and open to is in the
subform. When I try this i get an error stating there is no field call Work
Order Number.

KARL DEWEY said:
Instead of condition try adding the following actions --
GoToControl --- [Work Order Number]
FindRecord ---- [Forms]![Frm Work Order Status]![Qry Open Work
Orders].[Form]![Work Order Number]

--
Build a little, test a little.


john said:
I have a form (repair status) the has the same field (work order #) as
another form which is actually a subform(work order detail) to a main form
(Customer data). What I want to do is double click on the field (work order
#) and have it open the form (customer data)/(work order detail) at that
specific record.

I selected On Dbl Click to run a macro that opens the form where both field
match. That works but it pulls the customer data form and the work order
detail but it goes to the first work order detail associated to that customer
not the specific on i clicked on. Any idea what i'm doing wrong.

This is the condition i'm using in the macro.

[Work Order Number]=[Forms]![Frm Work Order Status]![Qry Open Work
Orders].[Form]![Work Order Number]
Click to expand...
Click to expand...
Click to expand...
 
Back
Top