Data Access Page: Autofill repeating fields with data from another field.

[abell86]

I'm designing a data access page for my access database that is going to be used for timesheet processing. I have a data-entry page that has only the blank entry showing, and any new entries that are added while accessing the entry page. Each entry requires the entry of a common field, "Labor Code," and I would like to only enter this once, possibly even scanning it in using a barcode reader. My idea was to have a single field located above the header that the value is enterred into, and then linking that field to the field in each entry so it doesn't have to be retyped in for every entry. Ideally I would hide this repeating field so the user doesn't see it at all and possibly cut down on confusion.

I've tried looking around and I cannot find any way of doing this within the page and not linking to another table in the database. If I could do this within the structure of the page and not have to send and receive data to the db that would be great.

Any ideas??

Thanks