autofill a field on a form with default value

D

Donna

I have tblApplication Table. I have a tblContract Table. I have a continuous
form that uses these 2 tables to allow the user to create a quick contract
for everyone who has submitted an application. In most cases the "start"
(date) field will always be the same date. So I would like a way to have the
default value of the "frmCreateContract.Start" to automatically fill in the
field when it is null. Once "Start" has a value, or is edited, I would want
that value to hold & not resort back to the default everytime the form is
opened.

Right now I have the default value of the form field set to 9/16/2008 but
when I open the form, all records show up with the "Start" field empty. Then
the last record or next NEW record waiting to be created has the default
value in it. But I need it to fill in all the records I'm showing -- quickly.

Can this be done without having to copy & paste the start date into each
record?
 
R

Rockn

You could also do some VBA for the form when it is submitted to test the
field for a Null value and if it is Null insert the current date or whatever
date you want.
 

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