Create record on form open.

Hello all.

I have a Invoice form that retrieves data from a previously opened Accounts
form. The Invoice number field on the Invoice form is used to track which
charges belong to that invoice via a query, so before you can start adding
any charges to the invoice, it's record has to be created otherwise you have
a charge that belongs to null invoice. The only problem is that the Date
field is set to automatically put todays date in, and all other data for the
Invoice is loaded from the Account form. The autonumber field does not
assign a value until I manually enter something into a field on the form.
How can I make it automatically create the record using the data that is
entered from other sources so that the charges query can run correctly.

Cory