If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Question: adding records to a continuous form using controls in the footer
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 |
#3
|
|||
|
|||
Question: adding records to a continuous form using controls in the footer
Thanks for the info, I'll try that out now.
John Vinson wrote in message . .. On 14 Jun 2004 19:49:53 -0700, (Matt) wrote: 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. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|