inputting data into a form to get back to original table

[Guest]

I am populating part of records for a form from a previous form- we'll call
it receiving(query/table. Example lot#,recd date,qty recd. the original form
is based on a query because I needed to steal the product name and company
name from a product table that is already in the database so the user doesn't
have to input that.

I have another form we'll call it the Quality form that gets populated (some
of the fields) from the receiving form(and some additional fields that I
would like them to input-qc table) where the quality dept. needs to get a
sample and record its test values.

I changed the join type to include all records from the receiving form and
they all look great. However, I can only edit the records when it is a NEW
record. I actually wouldn't ever want to do that. I want to just add data
to the fields for the quality dept. example sample date, sample id
-autonumber.

Any ideas???
Thanks,
Barb

 

[Lynn Trapp]

Barb,
I'm not sure I followed you completely, but you might try setting the Data
Entry property of the Quality form to Yes.

 

[Guest]

That doesn't help. When I set the data entry property to yes on the quality
form it only lets me see that one record and the records for fields from the
receiving table example lot#, date, are not visible. Wondering if I need to
do form/subform . bottom line need to basing new form (quality) on records
from the receiving form and be able to add additinal fields to existing
records.ie. sample date, test values.
Thanks
Barb

 

[Lynn Trapp]

You may find that creating a subform would be the best approach.