Date Field

[Guest]

I have a form that users use to collect census data for 70 programs once
every Wednesday. I have that data going to a table titled census event.
Each record can be identified by the autoCensusID, the Census Date and the
Program ID. Right now I have the form set to the current date so that when
the user opens it to start entering data, she does not have to fill in the
date with every record.

The problem is that some of the programs do not all report on that one
Wednesday. If they report in on Thursday and she tries to enter their data
into the table for Wednesday, the form automatically assigns it to the
current date. So I have 69 records for Wednesday and 1 record for Thursday.
Doesnt work.

I need the user to be able to choose a date when she starts to enter data
and then all the data she enters during that session is assigned that date.

 

[Guest]

I need the user to be able to choose a date when she starts to enter data
and then all the data she enters during that session is assigned that date.
Use a form to enter the date and have it as the default.

 

[Guest]

Thatnks for your fast response.

Can you suggest the code to "have it as the default?"

 

[John W. Vinson]

Thatnks for your fast response.

Can you suggest the code to "have it as the default?"

If you want the form to always enter data for the most recent Wednesday, set
the DefaultValue property of the date field's bound control to

dateadd("d", 1-weekday(date(),4),date())


John W. Vinson [MVP]

 

[Guest]

On your data entry form have an unbound text field to enter the date to be
used.
Then set the default property of the bound textbox to
[Forms]![YourDataEntryFormName]![UnboundTextBoxName]

 

[Guest]

Brilliant!

Thanks
--
Thanks

On your data entry form have an unbound text field to enter the date to be
used.
Then set the default property of the bound textbox to
[Forms]![YourDataEntryFormName]![UnboundTextBoxName]
--
KARL DEWEY
Build a little - Test a little

Thatnks for your fast response.

Can you suggest the code to "have it as the default?"