Problem with radio buttons bound control

[netsmurph]

I have a form (continious style) that is bound to an uneditable query.

What i want is for users to be able to select one of the two radio buttons which will allow them to edit one of the fields (which is unbound, but will update the appropriate table on update of the record).

My main issue is this - i cannot bind the radio options to a field in the underlying query (as is not updatable),

or

if i use an unbound control, when one is selected, it all of the radio buttons in the form are updated to the one selected.

Does anyone know if there is any kind of solution to this problem.

Many thanks in advance.

 

[ProgramError]

I would include all the unbound fields in the query ad have a master control on the the form which either locks or unlocks the textboxes in one instance.


Ian Mayor (UK)
Program Error
There's ALWAYS more than one way to skin a cat!
But only one way to get it RIGHT!

 

[netsmurph]

Ian

Thanks for your reply - i am not sure exactly how to do this!

What i have tried is having a button to click to edit a particular field - but when this is clicked to unlock the unbound control, if i enter in data into it, the same data entered appears in all records in that field on the form (it is displayed like a datasheet).

What I am thinking is maybe i could make a table based on my uneditable query, that will in turn update the necessary tables.

I am not sure if this will be very inefficient to run it this way - could anyone comment if they have implemented a form this way?

Many thanks

Andrew