THIS IS A WEIRD COMBO

B

bladelock

I used the wizard to create a combo box "Find" a record (based on a field in
the table) on my form, which works fine. But, here is the strange part, I
added this into the "BeforeUpdate" of the form.

If Isnull(txtName) then
cancel=true
Endif

Which works fine, but when I go to use the combo box and select a record on
the drop down. I get a message "You canceled the previous operation"

What happened?
 
D

Dirk Goldgar

bladelock said:
I used the wizard to create a combo box "Find" a record (based on a
field in the table) on my form, which works fine. But, here is the
strange part, I added this into the "BeforeUpdate" of the form.

If Isnull(txtName) then
cancel=true
Endif

Which works fine, but when I go to use the combo box and select a
record on the drop down. I get a message "You canceled the previous
operation"

What happened?
Click to expand...

I suspect that your combo box is bound to a field. You shouldn't do
that with a "navigation" combo box, as every attempt to choose a new
record to go to also changes the current record.
 
Top