want to have date from 1 field automatically in another field (but allow edits)

[_Bigred]

creating db in access 2000, but will ultimately use it on a single machine
using access 2003.

I have a table (with forms & reports based on it).

I have some fields
EntryDate & ActionDate

I would like to automatically have the EntryDate entered into the
ActionDate, but still allow the user to be able to change the ActionDate
after is originally inputted.

The scenario is I need to keep the db very simple, when a occupants goes in
say Room 1 on 9/6/05 this date would be the EntryDate - this date would rank
them on a list for a single room availability (i would want to be able to
manually change the ActionDate - if they decline a single room or get their
single room revoked at a future date).

TIA,
_Bigred

 

[Gijs Beukenoot]

From _Bigred :

creating db in access 2000, but will ultimately use it on a single machine
using access 2003.

I have a table (with forms & reports based on it).

I have some fields
EntryDate & ActionDate

I would like to automatically have the EntryDate entered into the ActionDate,
but still allow the user to be able to change the ActionDate after is
originally inputted.

The scenario is I need to keep the db very simple, when a occupants goes in
say Room 1 on 9/6/05 this date would be the EntryDate - this date would rank
them on a list for a single room availability (i would want to be able to
manually change the ActionDate - if they decline a single room or get their
single room revoked at a future date).

TIA,
_Bigred

Use the afterupdate event of the EntryDate for:
if IsNull(Me.Actiondate) then me.actiondate = me.Entrydate

So, when the actiondate = blank, the entrydate is filled in. When the
actiondate is already there, nothing happens.

 

[_Bigred]

I'll try that out and let you know.
Thanks
_Bigred