opening forms

D

Deanna

Hi I am trying to create a employee database that will open other forms that
data can be placed in (tick boxes) to show the employees' level of
competence. When i create the macro to open the form it doesn't correspond
to the employee i have selected in the original form, it just goes stright to
the first record of that form. I'm thinking there is something I'm not
getting right in the relationships? They are connected via their ID numbers
atm (which is the primary key). Is there a way i can make this happen? I'm
also unaware how to create an expression for the 'Go To' macro tool which i
thought might help me?

Please help i am absoloutly lost!
 
B

banem2

Hi I am trying to create a employee database that will open other forms that
data can be placed in (tick boxes) to show the employees' level of
competence.  When i create the macro to open the form it doesn't correspond
to the employee i have selected in the original form, it just goes stright to
the first record of that form.  I'm thinking there is something I'm not
getting right in the relationships?  They are connected via their ID numbers
atm (which is the primary key).  Is there a way i can make this happen? I'm
also unaware how to create an expression for the 'Go To' macro tool whichi
thought might help me?

Please help i am absoloutly lost!
Click to expand...

Relationships has nothing with the issue you have. What you need is to
open second form in filtered mode by first form record. Rather use VBA
for this action ([Event Procedure]):

docmd.OpenForm "frmFormName", , ,"IDEmployee = " & IDEmployee

Change form name and ID fields accordingly to your object names. This
command opens second form (frmFormName) and puts filter on that form
(IDEmployee) by first form ID (second IDEmployee).

Regards,
Branislav Mihaljev
Microsoft Access MVP
 
Top