List box error
 

How do I set focus away from a list box? I have 4 list boxes on a tab
control that are interdependant. I.e. the value of one becomes criteria to
requery the next. When I requery the 1st list box, I set the focus to it and
set the List Index property to have a record selected to use in the second
list's query criteria. Then I need to do the same for the 2nd-4th list
boxes. The problem is that once I set the focus to the 1st list box, I can't
move it. SetFocus to the form executes, but the focus stays on the list box.
SetFocus to any other control causes 'Runtime Error 2115: The macro of
function set to the BeforeUpdate or ValidationRule property for this field is
preventing Microsoft Access from saving the data in the field.' I don't have
any functions set for either property

List box error
 

Sorry all. This was an Access question. Please disregard.

"4110" wrote:

How do I set focus away from a list box? I have 4 list boxes on a tab
control that are interdependant. I.e. the value of one becomes criteria to
requery the next. When I requery the 1st list box, I set the focus to it and
set the List Index property to have a record selected to use in the second
list's query criteria. Then I need to do the same for the 2nd-4th list
boxes. The problem is that once I set the focus to the 1st list box, I can't
move it. SetFocus to the form executes, but the focus stays on the list box.
SetFocus to any other control causes 'Runtime Error 2115: The macro of
function set to the BeforeUpdate or ValidationRule property for this field is
preventing Microsoft Access from saving the data in the field.' I don't have
any functions set for either property