M
Max Moor
Hi All,
I have a form in Access 2002. There is a listbox that displays
records. The main form has the bound column of the listbox as criteria in
its row source. The listbox click event requeries the form. This is all
pretty standard, I think.
There is also a combobox and a few checkboxes that are referenced when
I build the SQL for the listbox. In the combobox's AfterUpdate event code,
I update the listbox SQL, requery the listbox, select the first record,
then requery the form.
The problem comes when I try to set the selected record in the listbox
after requerying it. I get the error:
"The macro or function set to the BeforeUpdate or ValidationRule property
for this field is preventing MyApp from saving the data in the field."
I don't have a BeforeUpdate event anywhere on the form, nor do I use a
validation rule anywhere. I can't figure out what access is trying to
save. I assume that if I'm running the AfterUpdate code for the combobox
that it has essentially finished. The listbox requeries without error.
It's only when I try to select a record before requerying the form.
Does anyone have any idea what toes I'm stepping on?
Regards,
Max
I have a form in Access 2002. There is a listbox that displays
records. The main form has the bound column of the listbox as criteria in
its row source. The listbox click event requeries the form. This is all
pretty standard, I think.
There is also a combobox and a few checkboxes that are referenced when
I build the SQL for the listbox. In the combobox's AfterUpdate event code,
I update the listbox SQL, requery the listbox, select the first record,
then requery the form.
The problem comes when I try to set the selected record in the listbox
after requerying it. I get the error:
"The macro or function set to the BeforeUpdate or ValidationRule property
for this field is preventing MyApp from saving the data in the field."
I don't have a BeforeUpdate event anywhere on the form, nor do I use a
validation rule anywhere. I can't figure out what access is trying to
save. I assume that if I'm running the AfterUpdate code for the combobox
that it has essentially finished. The listbox requeries without error.
It's only when I try to select a record before requerying the form.
Does anyone have any idea what toes I'm stepping on?
Regards,
Max