Check just one unbound Radio buttons

[Albano]

Hi,

I have a form (continious style) that is bound to a tablle, and I have unbounds radio buttons that are created as much as the records. What i want is for users to be able to select just one of the radio buttons (meaning they select the record), now when I select one all stay selected.

Thanks,

Albano

 

[Remou]

You cannot do much with unbound controls on continuous forms, as you have found.

 

[Crowley16]

you could create a temp table, load all your data into there, and then bound the form to that table...

--------------------
Procrastinate Now!

 

[MajP]

I often just put a bolean field in the table "blnIsSelected" . You may need to run an update query to clear out the checks once the form closes.

 

[Albano]

Hi,

I tray to put a boolean field on the table, but when I select one all stay selected, thirs any whay to make sameting like a options group (select just one options)

Albano

 

[TheAceMan1]

How are ya Albano . . .

[blue]I tray to put a boolean field on the table, but when I select one all stay selected . . .[/blue]

Did you add the new yes/no field to the form?

See Ya! . . . . . .

 

[idbr]

Hi Albano,

You'll need to run a procedure on the After_Update event of the check box to clear out the other selected record in order to only be able to select one record at a time. Something like:

DoCmd.RunSQL "UPDATE YourTable SET blnIsSelected = 0 WHERE YourIDField <> " & Me.YourIDField & ";"

Me.Requery

Should do the trick, although could be a bit slow if you have a lot of data on your form...

Cheers, Iain