creating subforms to link data

[stacie]

Okay, I have a table created with a form. The table contains patient names,
ssn, admit dates, nurse and other information as that. I created a form from
this table. I need to create another form based on this table but with an
added field. I do not want the user to have to enter the same identifying
information again as it is already in the database. For example, another
department enters discharge dates, charges, payments received, etc. I want
to know how can I create that form and just have the user only have to
complete fields not alread in the database. Can anyone give me a simple
solution?

 

[Klatuu]

Is there any reason you can't just add the additional fields to the current
form's record source and put controls on the form for these new fields?

If is is a security matter, you can define who has rights to do what in the
form based on user id, or some other criteria. This would be preferrable to
creating an additional form to have to maintain.