you can't assign a value to this object #Name error

T

Ted

i am using the following code


Private Sub IRB_Number_AfterUpdate()
Me.IRB_Number.Requery
Me.Title.SetFocus
Me.Title = " " ' <---- has the yellow
Me.Title.Requery
End Sub


and

Private Sub Title_AfterUpdate()
Me.Title.Requery
End Sub

to sequentially populate to interdependent combobox controls on my a2k
databases's form.

when i select a value from the IRB Number combo box, the idea is to have the
cursor move to the next control on the form, Title, and have it give the
title which belongs to the IRB number as the one available to be selected
from the l/u table into the combobox's 'window'. [you might think of IRB
number as akin to a field like States and the Title field as akin to Cities -
and this process as helping limit the range of values of City available to
the user once the value of States is chosen]


once the IRB number's chosen, the Title control is filled with an 'error',
i.e. "#Name?" and the debugger opens to reveal the line in the code above
highlighted in yellow.

this used to work and i can't figure out why it won't. arrrrgh :-(
 
Top