pulling data as a label

[Cameron]

I am fairly new to Access, so I appreciate any input. I
have two tables:
1) Shift Duties with fields of Id, D1, D2, D3
2) Status with fields of Id, Completed, Initials

What I am trying to do is design a form that will pull in
the data from D1, D2 and D3 as labels so that they are
not editable and also display Completed and Initials so
staff can check off thier shift duties.

I tried doing a control source with =[Shift Duties]!D1
but I get #NAME?

TIA

 

[PC Datasheet]

You need to redesign your tables:

TblShiftDuty
ShiftDutyID
ShiftDuty

TblCompletedShiftDuty
CompletedShiftDutyID
ShiftDutyID
Initials

 

[Norm]

If the fields you are trying to pull in are not part of your form's record source then you will get that error. What you can do is either somehow include the field into your record source (as part of the table or create a query that includes it and use the query as the form's record source). You can also use the domain commands (dlookup, etc.) but they seem to be pretty slow.