Bound Form Controls in Headers

  • Thread starter Thread starter DumbWithData
  • Start date Start date
D

DumbWithData

Let me explain the application and then someone may be able to help with a
solution. The form is linked to a table for recording work items. This table
has the following fields: Date, Personnel, Item Number, Location, Amount. I
want to make a form for the but given that an individual person only enters
this data for themself and does multiple items each day, I would like the
date and personnel fields to be contained in the header so each new record on
the form will have the same date and personnel added to it once the indvidual
enters them for the first record. Does anyone have any ideas. In advance,
thank you.
 
It is possible to do it that way, but the better way is to read the UserName
from either Access security (if it's enabled) or Windows login:

http://www.mvps.org/access/api/api0008.htm

Date current date can easily be added to each new record by setting the
datefield's defaultvalue property to:

=Date()
 
Back
Top