Help needed with a form

[associates]

Hi,

I have a quick question that i need to get some help with.

In a form, there is two comboboxes and a textbox. The textbox is disabled and locked because nobody is allowed to enter data to it. It contains the value which is from the result of choosing the two comboboxes.

example;
in table "Project"
Name Subject Score
michael IPA32 80
.
.

CB=combo box

from the dropdown, CB1 = "michael", CB2 = "IPA32". Then 80 will appear in textbox. However, there is some cases where the score doesn't exist or null (not found in the table). Is there a way to check on the spot if the textbox is empty or not as soon as CB1 and CB2 have been selected. At the moment, i use the form_beforeupdate to check the textbox. If it is, cancel is true. the whole form disappears which i don't want it to happen.

Your help is greatly appreciated.

Thank you in advance

 

[RuralGuy]

Are you saying that setting Cancel = True in the BeforeUpdate event of the form causes the whole form to disappear? If so, this is not normal behavior and something else is going on that should be investigated.