Copying information

rwpetrie

Registered User.
Local time
Today, 18:21
Joined
Dec 12, 2000
Messages
25
How can I enter data into a form, then hit a button that will save/copy some information that will automatically be entered for the user as it opens a new record?

I am using a Job # and a PO#. I want the database form to keep a new Job # at the top, adding it to the new record, but permit new items to be purchased on a different PO#.
 
you can use the defaultvalue property of your control.

me![Job #].defaultvalue = me![Job #].Value

you can do this in the controls afterupdate event so your user does not have to do anything extra.

ntp
 

Users who are viewing this thread

Back
Top Bottom