Add Combobox to subform

[Precips1]

Hi,

Something weird going on!

On my main form I have a subform which holds two table values. [Roles] & [TrainLevel] example of this looks like this:

Plant Manager - T1
Assistant - T2

and so on for about 12 rows with different roles, each with different training levels.

This subform is then based on a query: [qryRoleEventWithRoles] which also looks at all the other selections, selected on the main form.
eg. User selects a training course on the main form, this then changes the subform and shows what level of training each role requires training in, T1, T2 etc..

All this has been working fine for months, almost a year. Each selection on the subform is based on using two combo boxes [Role] & [TrainingLevel] these are both setup on the subform and using the autonumber field, RolesID and TraininglevelID from two separate tables.

Like I say, this has been working fine. Now, all of a sudden, they've stopped working and telling me I can't change the valve because there bound to an autonumber value. or something like that.

Anyone help would be much appreciated.

Thanks
Mike

 

[David R]

Posting the exact error (screenshot or typed out) would help immensely.

 

[Precips1]

Hello David, hope you can help.

See attached. Pic1 shows a screen shot when access running. The idea is after selecting SOP on the right, the roles subform adjusts to suit the level of training required for each role. T1, T2, T3 or Not required.

Pic2 shows I have IDs selected to populate the combo's from two tables. RolesID & TrainLevelID.

Each device properties look like this:
RolesID: Control Source = RolesID and Row Source = SELECT [tblRoles].[RolesID], [tblRoles].[Role] FROM [tblRoles];

TrainLevelID: Control Source = TrainLevelID and Row Source = SELECT tblTrainLevel.TrainLevelID, tblTrainLevel.Level FROM tblTrainLevel;

Everything else in properties are the same.

Problem now is, When I try and select a trainlevel from T1 to T2 access errors and says "Control cant be edited, its bound to an autonumber field"

Like I said before, its been working for months.

Thanks for the help
Mike

 

[Precips1]

Problem solved...By me.