filter data from double click on record line

[steve111]

hi,

I have a attached a sample database to show you my problem
the form "stores1" is the navigation form . in side that I have 2 subforms

the first form I have a macro in it that when you double click it ( say the first line ) the stocklist file will appear on the part that I double clicked on IE 5096B02066

this did work and does work in the old access I have but now I put these forms into the navigation form I cannot get it to work

I am having this problem on many forms even if I try to put a text box into the navigation window that ref a field on one of the subforms

any help appreciated
steve

 

[JHB]

If open your "Stores1" form and click on record in the first subform, the second subform get updated to reflect the what I click on!
So what doesn't work?

 

[steve111]

hi

when you double click on the first line of the first form . another form should appear. this form is called " stocklist " and is should have filtered to the same stock number you double clicked on

not the subform

thanks
steve

 

[JHB]

The problem is, you are not updating your query and macro with the new reference when you add a form or change a formname + the name for the stocklist form was also wrong in the macro.
Ex. in the query you reference was:

 [Forms]![stores]![Supplier parts Ordered].[Form]![stock number]

But the correct one is:

[Forms]![Stores[B][COLOR=Red]1[/COLOR][/B]]![B][COLOR=Red][NavigationSubform][/COLOR][/B].[Form]![Supplier parts Ordered]![stock number]

The same appear in the macro.
Database attached.

 

[steve111]

thank you
really appreciate your help works great now

steve

 

[steve111]

hi
I have tired to copy that formula in to a different form without success could you please tell me what is wrong

I want to do the same thing in the first form . select the first row and the stocklist table is shown

thanks steve

 

[JHB]

Hmm - I don't know how you're fiddling around with the reference, but the right one is:

[Forms]![Purchasing Form]![NavigationSubform].[Form]![child68]![stock number]

 

[steve111]

hi

I am now getting the stocklist form up now but it does not filter the stock number we selected

thanks
steve

 

[steve111]

hi

I am also getting the form " requisition " appear
as well as the stocklist form

sorry,

macro was wrong on this item

thanks
steve