Create record on form open.

C

Cory

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top