creating a jump to report inside a field

[bal_sagoth]

I have a table that lists computer info. and one that list employee info. On
the computer table there is a employee number field. I would like to be able
to create a macro that will let me jump to the report in the employee table
that this number points to when i double click on that feild in the computer
table.

example
#13 is john. in the computer table when 13 in the number field comes up.
Click on that field (#13 field) and Johns employee record will come up in
another window.

I know I can create a macro to have every employee in the employee table
come up when I double click on the employee # field in the computer table. I
do not know how to take that # and use it to bring up a specific report in
the employee table

 

[Jeff Boyce]

First, don't work directly in the tables. In Access, tables store data, and
forms display it.

There's a lot more control and a host of events in forms that you won't have
if you try to work directly in the tables.

Next, in Access, tables don't have "reports". I don't understand what you
mean by "jump to the report in the employee table".

If you work in a form, you can add code behind the Double-Click event of a
control, and in that code, open another form, open a report, or ...

Regards

Jeff Boyce
Microsoft Office/Access MVP