MS Access 2007

[dichotomous]

I have used Access to build our Health and Safety system data base. (I'm reasonably new to access BTW.

All my data is in tables. All my reports are based on queries.

I have three forms. Accident Register (linked to a table), Investigation Register (also with it's own table) and Hazard Register (ditto).

The accident register is a tabbed form (ease of use and economy of space) I want code (or Macro) for a button that links me through (from the accident record I'm working on) to the Investigation register and opens at this specific accident, or, this specific record.

Investigation Register has an Accident Link Field which relates the two tables (I've done this for reporting purposes).

Any light you can shed would be wonderful.

 

[pbaldy]

Like so?

http://www.baldyweb.com/wherecondition.htm

 

[dichotomous]

Thank you Paul.

So, following on from that, Ideally, It would be really cool to be able to: Open Investigation Register from Accident Register, having that function create a new record automatically linked - what I mean is: I've opened a new accident. It is record 115(access assigned ID). Now, I decide to open an investigation. I want the investition to open with its own ID of course, but, for the Accident Link Feild to populate with the ID of the Accident Register, i.e, 115.

????

Alastair.

 

[pbaldy]

You could use GoToRecord to move the form to a new record or open it in add mode, then copy the key value from the current form to the new form.