Solved select one of checkbox

[hatmak]

hatmak

OK. The attached db uses code to do as you requested.
BUT, as you have been advised, that this is NOT the best way to handle this data. I have to say that I'm not sure how much interest members will have in helping with any future issues that may arise from using this solution. Good luck with your project.

bob fitz

many thanks

 

[Pat Hartman]

I can't believe Bob loaded the gun for you.

 

[Gasman]

I can't believe Bob loaded the gun for you.

Well to be fair, I loaded the gun first,. I just put the bullets in back to front in error.

However from the previous posts of the o/p I could not see them listening to reason.

 

[bob fitz]

I can't believe Bob loaded the gun for you.

It's not my fault

Well to be fair, I loaded the gun first,. I just put the bullets in back to front in error.

However from the previous posts of the o/p I could not see them listening to reason.

All I did was turn the bullets around

 

[Pat Hartman]

You are a kinder person than I It's one thing to write code and update a poster's project to do the technically correct thing (which i did in this case) and quite another to write code and update the poster's project to do something I would never, ever consider doing for money let alone for free.

 

[Gasman]

Pat,
When a person just posts the same post over and over again, in the same thread, I assume that they are not going to listen to reason.? Their mind is set, and no words are going to change that.
In that case you may was well put them out of their misery.

 

[hatmak]

I would probably go with

Me.Control = NOT Me.OtherControl

in an event like AfterUpdate for just what you are asking?

many thanks
Gasman