Sharing the same fields for two forms

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You should be able to use the same fields from a single table on multiple
forms. The first thing for you to check is if your queries are updatable. Try
opening the query directly and entering information. If it does not let you,
the query is the problem. If you are linking table together in a query, you
should have primary keys set up on the tables and have the relationship
between the tables defined. Also, the query cannot be a group by (or totals)
query.
 
Back
Top