Creating A Preliminary Data Entry Form

[Ian W.]

Hi.. Thanks in advance,

I'm looking to try to create a master form that proceeds my typical data
entry form. We have collected data riding along with truck drivers and would
like to enter this into our database. I'd like categories such as 'observer'
, 'date', 'driver', 'initial mileage', 'Vehicle type', and 'bin type' in a
preliminary form that a user will only have to fill out once prior to
entering their remaining stop data (each stop will be a new record with this
preliminary data automatically entered).

Do I need to clarify this further?

Thanks again,

Ian

 

[Ian W.]

That sounds easy. Any guidance on how to do that? (websites etc.)?

Thanks again Rick!

 

[Rick Brandt]

That sounds easy. Any guidance on how to do that? (websites etc.)?

Thanks again Rick!

Build your two tables first and set up the relationships between them.
Then you can click on the first table in the db window and press the
AutoForm button in the toolbar. Presto! You now have a form for that table.
Save it. Do the same to create a form for the second table.

Now open the first form in design view, then drag and drop the second form
from the db window onto the design view of your first form. This will
automatically create a subform for you and since you previously set up the
relationships between the tables, Access "should" automatically set the
MasterLink and ChildLink properties for the subform control. That is what
keeps the subform synchronized with the main form.

All that is left is cosmetics. You will want to arrange the controls
(inlcuding the subform control) on your main form as desired and you will
likely want to change the DefaultView property on the second form to either
Datasheet view or Continuous view so you can see more than one record at a
time on it.