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

 

[Cameron]

Thanks!
Did what you said but still get the #NAME? error

I recreated the tables as you suggested. [TblShiftDuty]!
[ShiftDutyID] is Primary key as is
[TblCompletedShiftDuty]![CompletedShiftDutyID] I have a
one to many relationship set up between [TblShiftDuty]!
[ShiftDutyID]and [TblCompletedShiftDuty]!
[CompletedShiftDutyID]

If I insert a text box on a form bound with: =[ShiftDuty]!
[ShiftDutyID] I get the error #NAME? Where am I going
wrong with this> Any help would be great!

Thanks

-----Original Message-----
You need to redesign your tables:

TblShiftDuty
ShiftDutyID
ShiftDuty

TblCompletedShiftDuty
CompletedShiftDutyID
ShiftDutyID
Initials


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

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

.

 

[Guest]

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.