Auto populating form

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have a form that is used to input contents of a vessel.
There are 30 vessels available. To simplify the table, I
have constructed it with the fields Vessel & Material (it
also has a date field and autonumber) as opposed to the
previous construction of 60 fields, one each for the
vessel and the material.

I would like to bring up the form and have 30 records
populated with the vessel IDs then allow the user to
select the material for each vessel. How would I code the
form to make this autopopulation happen.

If it helps, the 30 vessels are stored as the values for a
dropdown list on the form and also in a separate table
(maybe code to run through each value in the table and put
that in the vessel id field???)

Thanks in advance,

Jason
 
I would like to bring up the form and have 30 records
populated with the vessel IDs then allow the user to
select the material for each vessel. How would I code the
form to make this autopopulation happen.
Click to expand...

One way to do this is to base a continous Subform on a Query joining
the table of Containers (a thirty-row table) to this table, using an
Outer Join to show all Container records and matching contents
records. Be sure to include BOTH tables' ContainerID fields; the
ContainerID will automatically fill in when you add data to one of the
other fields.
 
Back
Top