Bound Form Controls in Headers

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.
 
A

Arvin Meyer [MVP]

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top