Editable Subform?

treva26

Registered User.
Local time
Today, 07:01
Joined
Sep 19, 2007
Messages
113
OK I have a Personnel database with a personnel form that has all the fields in it.

I want to create an Injuries form where you just select/type an employees name and then add injuries data to an injuries table (linked to the persons ID number in the Personnel database).

What is the best way to select the persons name?
I only want to be able to choose from current employees.


I have seen a form where the name is at the top and not editable and then there is a sub-form with the editable data. Is that a good method?
If so how do I make the main form not editable but the subform editable?

Ideally I would like to start typing the persons name and have a list come up showing employees whose name starts with what has been typed.
 
One way to think about it: if injuries is employee related then the Parent Form would be bound to Employees and the Subform bound Employees Injuries. To get there - ask before you get to bound Employee Form for the Employee Surname and First Name. Not only do you get to see historical injuries but you can simply add new Injuries to the Sub Form.

Simon
 

Users who are viewing this thread

Back
Top Bottom