Question: adding records to a continuous form using controls in the footer

[Matt]

Hi,

I have a question that will probably seem simple to everyone on this
board, but please have patience with me as I am just a beginner.

I have a database that tracks when various items are tested. My
database has two forms, one form describing the item, with lots of
detail information, and a nested continous subform, which keeps track
of test dates, as well as information associated with the test.

My question is, can I set up fields in the footer of the continuous
form so I may fill them out, then click a command button and have that
information added to the test data subform? Assume the relationship
between the two tables is correct.

Thanks,
Matt

 

[John Vinson]

My question is, can I set up fields in the footer of the continuous
form so I may fill them out, then click a command button and have that
information added to the test data subform? Assume the relationship
between the two tables is correct.

Well... you can; but that seems like an extra step. If you have the
Subform set up correctly, you can enter the data to the subform
directly. Why do you feel that you need to relay the data?

There are several ways you can do this - perhaps the simplest would be
an Append query with "calculated" fields such as

=Forms!formname!subformname.Form!txtFooterControl

for each field that you want inserted.

 

[Matt]

Thanks for the info, I'll try that out now.

Well... you can; but that seems like an extra step. If you have the
Subform set up correctly, you can enter the data to the subform
directly. Why do you feel that you need to relay the data?

There are several ways you can do this - perhaps the simplest would be
an Append query with "calculated" fields such as

=Forms!formname!subformname.Form!txtFooterControl

for each field that you want inserted.