Automatically default field on update.

  • Thread starter Thread starter HeatherD25
  • Start date Start date
H

HeatherD25

Hi,

I want to do an import and append of a really simple table -- it just has
EmployeeNumber and Status. This will be an import I do once a month. The
table I'm importing it to (tbl_EmployeeStatus) has one more field, though -
Month. I want to be able to select a drop-down on a form and then have the
"month" field default to the value on the drop-down for all of the records I
append to the table. How would I do this?

Thanks!
Heather
 
Heather

You asked for a rather specific "how to"...

May I offer an alternative approach? If you add a field to your
tbl_EmployeeStatus for [DateAdded] and use your append query to insert the
date[/time] of the append operation (with Date() or Now()), you can
determine the "Month" from the information in that field.

The downsides with having a field named "Month" include:
1) "Month" is a reserved word and Access may not treat it the way you
want to
2) "April" happens every year ... how do you know which 'year' the month
belongs to?!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top