Computethis
IS-IT--Management
I have a main form with a subform inside it - that works great... HOWEVER, I want to click on a command button and call up a sub/sub form....
I have a main orders database, with a one-many relationship to a sub-orders databse.
That suborders database also needs to have several databases connected to it.
The Main database (tblOrderLog) contains the main info on the order. The Sub Job database (tblSubJobs) contains the breakdonw of all the individual jobs for that main job. All that works great setting up a sub form within the orders.
I want to insert a comand button on the SubJobs form that opens the "Engineering Notes" form (tblEngNotes) for that specific subjob... When I create a command button via Access 97 it only opens the first Engineering notes with int he entire database and not the one that coorelates to the specific subjob number.
Hope you understand.. I have several sub/sub databases that need to attached that away.
HELP...
Mitch
I have a main orders database, with a one-many relationship to a sub-orders databse.
That suborders database also needs to have several databases connected to it.
The Main database (tblOrderLog) contains the main info on the order. The Sub Job database (tblSubJobs) contains the breakdonw of all the individual jobs for that main job. All that works great setting up a sub form within the orders.
I want to insert a comand button on the SubJobs form that opens the "Engineering Notes" form (tblEngNotes) for that specific subjob... When I create a command button via Access 97 it only opens the first Engineering notes with int he entire database and not the one that coorelates to the specific subjob number.
Hope you understand.. I have several sub/sub databases that need to attached that away.
HELP...
Mitch