Push values into linked new form

[CW]

I have a main Orders form and an Invoices form. They are both based on the
same table (Main).
I have a command button on the Orders form that opens the Invoice form in
Add mode so that I can create a new invoice for the current order.
I want the forms to be linked (by Ref) and I want several of the values on
the newly created invoice form to be populated automatically i.e. ref, client
name, and a couple of others.
How can I do this, please?
Many thanks
CW

 

[Jeff Boyce]

Based on your description ("both based on the same table"), you have a ...
spreadsheet! (Unless your business rule states that an Order can only have
one Invoice...)

If all the data is in one table, why are you using two forms?

An alternate approach would be to use a single form, and use a tab control
to display different "sets" of data from the record (e.g., Order info and
Invoice info - two tabs).

Regards

Jeff Boyce
Microsoft Office/Access MVP