Gram123
Thread Starter
- Joined
- Mar 15, 2001
- Messages
- 1,829
Hello,
I'm trying to set up an Access db and am having a small problem.
I have a main form with a subform with "Invoice Number" as a linked field.
When an invoice number is typed into the main 'parent' form, it is automatically entered on the subform. It saves successfully (as a value) to the table behind the subform. Fine.
However, I also have another form (Log) which is opened when a command button is clicked on the main form. I want the same thing to happen with the invoice number as on the subform - i.e. I want the invoice number to appear automatically on this additional Log form, and to save to the Log table when I save the (Log) record.
I can do the first part - by simply referring to the control on the main form, I can display the invoice number on the Log form:
=[Forms]![MainForm]![InvoiceNumber]
, but this doesn't save the invoice number as a value in the Log table.
Can this be done relatively easily?
Obviously the subform works correctly because of the parent-child link, and the Log form doesn't have such a link. Can I create one? Or can I do something else to convert the displayed invoice number into a value that will save?
Cheers
Gram
I'm trying to set up an Access db and am having a small problem.
I have a main form with a subform with "Invoice Number" as a linked field.
When an invoice number is typed into the main 'parent' form, it is automatically entered on the subform. It saves successfully (as a value) to the table behind the subform. Fine.
However, I also have another form (Log) which is opened when a command button is clicked on the main form. I want the same thing to happen with the invoice number as on the subform - i.e. I want the invoice number to appear automatically on this additional Log form, and to save to the Log table when I save the (Log) record.
I can do the first part - by simply referring to the control on the main form, I can display the invoice number on the Log form:
=[Forms]![MainForm]![InvoiceNumber]
, but this doesn't save the invoice number as a value in the Log table.
Can this be done relatively easily?
Obviously the subform works correctly because of the parent-child link, and the Log form doesn't have such a link. Can I create one? Or can I do something else to convert the displayed invoice number into a value that will save?
Cheers
Gram