Issues with forms and subforms

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

Guest

I'm new to Access, and working on a project to track a lot of information on
tasks in my department. I've set up a table for the information, and I've
tried to design three separate forms to populate this table, to correspond
with the three phases of a project. Does Access insist that an entire line
of a table is filled in on one form? I want the second and third form to
find the record and allow the user to fill in more information on the same
job, but I'm getting messages about needing more fields to be filled out
before leaving the screen. I have set all the fields to required/no.
Also, I have some additional tables set up on the many side, but when I
insert a subform, I can't get it to accept multiple lines. I think I'm
missing some setting in the parent form, but I can't find it in my books or
on line. If the parent table has an autonum for it's key and the child table
has the same name field set to long integer, with a one/many link, won't
Access populate the integer field with the autonum from the parent table
automatically? I don't want my users to see or touch those numbers.
 
Back
Top