Problem With Form Buttons

[mattman110]

i have two forms and running access 2007

i want a button to go from one form the the other and query the data as it goes.
but
when i have this macro behind the button it goes from the form to the other form and provides a box asking for a value to search for. no matter how hard i try i cant resolve this and get it to query the data as it goes ,with my current skill Levi i am stuck please help :banghead:

below are the macros on both forms

From patch to devices
Devices Details, Form, , "[Device / Computer Name]=" & "'" & [Patched From] & "'", , Normal

from devices to patch
Patch, Form, , "[Patched From]=" & "'" & [Device / Computer Name] & "'", , Normal

any help would be welcomed

 

[madefemere]

Hello,

Look at helps of the Docmd.OpenForm's method !
Your code must be like :

Docmd.OpenForm acForm, "Devices Details",, , "[Device / Computer Name]=" & "'" & [Patched From] & "'",

Have a good continuation