Update a control in a form from another control

[Terpsi]

Never mind - figured it out!



Hello all,

I am having issue with some code that worked without issue in 2003 but now it 2007, it will not run.

I have two list boxes, that when the user selects values and hits "GO", it used to copy the new values to locked form fields.

Never mind! Figured it out!

Here is the code that worked in 2003:
Me.ScheduleID = Me.AvClass

Me.AvClass is the listbox. Me.ScheduleID is a foreign key (not an autonumber)

In 2007, it gets stuck on this step saying: "You can't assign a value to this object".

I have changed anything else from 2003 to 2007 but the code will not set the value of the control.

Any ideas?

Please advise and thank you!

[alansidman]

What happens when you change the code to:

Me.ScheduleID = Me.AvClass.value

Alan