Need some help ....

To simply put it, I have a form with a populated combo box and 2 radio 
buttons. I need the radio buttons to change the value in the combo box.

Whenever I do this I receive this error and the combo box is not updated.


Run-time error '2115 - The macro or function set to the BeforeUpdate or 
Validation Rule property for this field is preventing [program name] from 
saving data in the field. 

Any help on this is muchly appreciated!

QTNM 

The combo box is bound to a table of values:

Lamp Type        Lamp Description
F15              18" Lamp
F25              30" Lamp
...

Where the bound field is the Lamp Type.

Any direction on this issue would be muchly appreciated.

QTNM  = ) 


> Need some help ....

> To simply put it, I have a form with a populated combo box and 2 radio 
b> uttons. I need the radio buttons to change the value in the combo box.

> Whenever I do this I receive this error and the combo box is not updated.

> 
R> un-time error '2115 - The macro or function set to the BeforeUpdate or 
V> alidation Rule property for this field is preventing [program name] 
from 
s> aving data in the field. 

> Any help on this is muchly appreciated!

> QTNM 

1) Check BeforeUpdate event for the named combo box on the form.
     a)  Open the form in design mode
     b)   Click the combo box
     c)   Open properties dialogue form 
     d)   Click Events tab and check if there is anything in BeforeUpdate event

2) Check table design for any validation rules for the control source for the named combo box
    a)   Open the table in design mode
    b)   Click the required field (control source for combo box)
    c)   Click General tab
    d)   Check if there is anything in Validation Rule box


____________________________________________________

John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________

The doors we open and close each day decide the lives we live
____________________________________________________

CONFIDENTIALITY & PRIVILEGE NOTICE
The information contained in this email message is intended for the named addressee only.  If you are not the intended recipient you
must not copy, distribute, take any action reliant on, or disclose any details of the information in this email to any other person
or organisation.  If you have received this email in error please notify us immediately.

>>> qtnm@s... 21/08/2002 3:21:06 >>>
Need some help ....

To simply put it, I have a form with a populated combo box and 2 radio 
buttons. I need the radio buttons to change the value in the combo box.

Whenever I do this I receive this error and the combo box is not updated.


Run-time error '2115 - The macro or function set to the BeforeUpdate or 
Validation Rule property for this field is preventing [program name] from 
saving data in the field. 

Any help on this is muchly appreciated!

QTNM