Default value from previous record


G

Guest

I have a data entry form thas has 4 fields (id, date, location, person) and
10 option groups corresponding to questions from a survey. Many surveys are
entered at once, so the information for date, location, person are the same
for each data entry session. I am trying to carry over the date, location,
person fields to the next record. I have tried some VBA which allows
assigning all the default values from last record. The event procedure code
is supposed to exclude the option groups from carrying over, but they all do.
Is there an easier way to solve this, such as just carrying over the 4
fields, but not the option groups?
Thanks
 
Ad

Advertisements

G

Guest

You need two tables. The first one has the four fields mention with the id
field being the primary key.

The second table includes all the option groups plus an id field as the
foreign key.

That way you enter in the first 4 fields once and all the other data as
needed in the second table. The best way to do this is create a form based on
the first table and then on it put a subform based on the second table. Then
Access will put in the appropriate data into the FK id field of the second
table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top