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

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_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
 
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
Click to expand...

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.
 
Back
Top