inputting data into a form to get back to original table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Barb,
I'm not sure I followed you completely, but you might try setting the Data
Entry property of the Quality form to Yes.
 
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
 
Back
Top