bound to unknown field

[stretch66]

Hi,

Have two controls GroupID and Shift which are linked with Criteria:

SELECT tblShifts.Shift, tblShifts.GroupID
FROM tblShifts
WHERE (((tblShifts.GroupID)=[Forms]![fmPersonalDetails]![GroupID]));

Have two other controls which are Position and Grade with same type of link.

Problem is When I try to edit the Shift control an error message comes up saying 'cannot edit bound to unknown field 'Shift'.

Have checked each of the property fields with the Position and Grade controls and are the same. Spelling is the same in the table. Are there any other obvious things I should be looking at because I'm pretty new to this and cannot find the solution.

Would be grateful for some input/suggestions.

 

[supercharge]

It always help to attach a small sample .zip database for us to look in.

 

[stretch66]

Yep sorry....new to this forum business!

 

[le888]

Is this what you want?

Le

 

[stretch66]

Is this what you want?

Le

Thanx le888 that was nearly what I wanted but managed to do it now so that Shift is dependant on GroupID and Shift field is no longer visible so cannot be input. Apparently it is easy when you know how?

 

[le888]

Not quit sure understand your message. The Shift field is still visible.

Le

 

[stretch66]

Sorry,

What I did was made the Shift control no longer visible when the form was being edited otherwise the user would try and change the shift.

Did manage to solve it using Dlookup on the Shift control:
=DLookUp("[shift]","tblshifts","[groupid]=Forms![fmpersonaldetails]![groupid]")

Looked at your solution and I assumed you had sorted it on the New Starter form and couldn't see how you had done it. looked at both Row source properties and couldn't work it out but you've obviously come up with a simpler solution than me.

How did you do it?

 

[le888]

I have done a query , "qryEmployees" and put it in the source on the New Starter form . Take a look on the "qryEmployees" and on the New Starter form.

Hope this help,


Le

 

[stretch66]

OK Le have seen what you have done now and yes it is an easier implementation than mine. Only been doing this afew months so still learning and wasn't fully aware of how queries could be used but that will help in a lot of areas.

Thanx