G
Guest
I have a form that is called activity sheet. The user keys information in.
Once the information is keyed in, the users then opens another form called a
log. On the log there are some fields that are the same from the activity
sheet. I want the fields that are the activity sheet to be filled in
automatically to this log. Then the user only has to key in the fields that
are not on the activity sheet to complete there log information.
Currently, I used a main form and subforms on both forms and used different
queries using the same tables. Now when I want to key information in either
form, it will not allow me to add a new record or key data.
Is it possible to have the same fields from the same table and be used for
multiple forms?
Spending a lot of time getting frustrated. If anyone could help, I would
appreciate.
Thanks,
JS
Once the information is keyed in, the users then opens another form called a
log. On the log there are some fields that are the same from the activity
sheet. I want the fields that are the activity sheet to be filled in
automatically to this log. Then the user only has to key in the fields that
are not on the activity sheet to complete there log information.
Currently, I used a main form and subforms on both forms and used different
queries using the same tables. Now when I want to key information in either
form, it will not allow me to add a new record or key data.
Is it possible to have the same fields from the same table and be used for
multiple forms?
Spending a lot of time getting frustrated. If anyone could help, I would
appreciate.
Thanks,
JS