Problem - Option box not updating table

[stburke]

Hi all,
I have a series of option boxes in a form which after update they change the value from -1, 0, 1 to Yes, No, N/A and save them in the respective table. My problem is I set the option box default value to 1 to save time and end up not getting that data recorded in the table. It only records it if I change the option box from one value to another. Any Suggestions?

 

[Remou]

You could set the default value for the field in the table, rather than the control.

http://lessthandot.com

 

[dhookom]

after update" doesn't fire on a control without user interaction with the control or calling the code from some other event. You would need to set the value elsewhere.

If you want more help, please explain what you mean by "they change the value".

Duane
Hook'D on Access
MS Access MVP

 

[ProgramError]

set the default value in the table rather than in the option box

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[Remou]

erm.

http://lessthandot.com

 

[ProgramError]

ie the default field in the table not default property of the control

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[Remou]

As in what I said 23 Apr 09 11:13?

http://lessthandot.com

 

[ProgramError]

Oh so you did...

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.