Data Entry Form Question - Ungent please

[Mike]

Hi,

I have this data entry form which is used to enter
information on payments received by an employee. We issue
a recipt to anyone who make a payment and later enter
that data into the database using this form. I want to
make the date feild such that, it stays the same on the
first entry until I chnage it, since I may neeed to enter
50 recipts in one time and each time I add a new record I
have to enter date. Can this be done? Thanks in advance
for your help.

Regards,

Mike

 

[fredg]

Hi,

I have this data entry form which is used to enter
information on payments received by an employee. We issue
a recipt to anyone who make a payment and later enter
that data into the database using this form. I want to
make the date feild such that, it stays the same on the
first entry until I chnage it, since I may neeed to enter
50 recipts in one time and each time I add a new record I
have to enter date. Can this be done? Thanks in advance
for your help.

Regards,

Mike

If the dates are always entered in ascending date order, you can set
the Form's Default Value for the date field to:
=DMax("[DateField]","TableName")

 

[Mike]

Thx.

The DateField is the name of the date feild inmy table?
or the on the form?

Thanks,

Mike

-----Original Message-----

Hi,

I have this data entry form which is used to enter
information on payments received by an employee. We issue
a recipt to anyone who make a payment and later enter
that data into the database using this form. I want to
make the date feild such that, it stays the same on the
first entry until I chnage it, since I may neeed to enter
50 recipts in one time and each time I add a new record I
have to enter date. Can this be done? Thanks in advance
for your help.

Regards,

Mike

If the dates are always entered in ascending date order, you can set
the Form's Default Value for the date field to:
=DMax("[DateField]","TableName")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[fredg]

Thx.

The DateField is the name of the date feild inmy table?
or the on the form?

Thanks,

Mike

-----Original Message-----

Hi,

I have this data entry form which is used to enter
information on payments received by an employee. We issue
a recipt to anyone who make a payment and later enter
that data into the database using this form. I want to
make the date feild such that, it stays the same on the
first entry until I chnage it, since I may neeed to enter
50 recipts in one time and each time I add a new record I
have to enter date. Can this be done? Thanks in advance
for your help.

Regards,

Mike

If the dates are always entered in ascending date order, you can set
the Form's Default Value for the date field to:
=DMax("[DateField]","TableName")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

If the actual Table Field Name is [SalesDate], and the table name is
"tblSales", then the expression should read:

=DMax("[SalesDate]","tblSales")

This goes in the Default Value property of the Form control bound to
the date field in the table.

When you start a new record, this date will appear in the date field.
If you then wish to change the date, simply write the new date over
the default one, which will then become the new default if it is newer
than the previous one.