Ooen database using marco and fetch data

[steve111]

hi,

I have 2 databases,
1 called NCR, the other called MRS
The MRS is used for purchasing material , and creating customer orders, booking in parts etc
the NCR is used for recording errors.

therefore what I would like to do is
when a part is purchased and it has an error, an NCR ( NON COMFORMING REPORT ) will be issued.
one of the fields in the NCR is "PO NO" there is also a field in the MRS called "PO NO"

What I want to do is double click on the line and then this runs the macro opens up the NCR record where "PO NO " Matches

I know on the double click you can have the first line of the macro like this
Forms]![status]![rejected subform].[Form]![P/O No].[Visible]
but I do not know how to open the NCR database keep the visible and find the NCR

any help appreciated

steve

 

[steve111]

hi ,
I have managed to get to open the NCR database now
MSACCESS.EXE C:\Users\steve.kirk\Documents\bom\ncr.mdb

but when I try to select a form from NCR it still is looking at MRS any ideas how to change the focus from one database to the other

thanks
steve