Option groups

[mousemat]

Help

I have an option group on a form that populates a hidden text box, this works fine.

Everytime i press save & new record, the option group is still displaying the entry for the last record.

How can I stop this from happeneing and have the option group be blank each time?

Mousemat

 

[dcx693]

The reason this happens is the option group is not "bound" to anything so it keeps the same values from record to record. If you want to option group to be reset when you move from record to record, place some code in the On Current event of your form.

 

[mousemat]

Hi DCX

Thanks for your response. Your right, the option group is not bound.

Have searched to forum for similar problems but found none, any idea of the coding required? MS Help files wasn't helpful! (Surprise)

Mousemat

 

[indesisiv]

Set the default value of the frame to Null. Then when you go onto a new record it will be set to Null.

OR

In the form_current put something like
Me.Frame2.Value = Null

That should get you started.

Steve

 

[mousemat]

Steve

Me.Frame2.Value = Null

Worked a treat.

As usual in these things, the simple answers are staring us in the face. Hadn't even thought about that.

Thanks for your help