Full Version: Refresh Data
UtterAccess Forums > Microsoft® Access > Access Forms
TheCaptain
I have a bound, continuous form with two text boxes and one Check box. Is there a to make sure the user can only have 1 check box checked at a time instead of more than one? Thanks in advance.
heCaptain
theDBguy
If I understand your question correctly, you want the user to check the box on only one record that is shown on the continuous form, right?
If that's right, is the checkbox bound? If so, you could put a code in the BeforeUpdate event of the checkbox to see if another checkbox has already been checked using the DCount() function.
Hope that helps...
TheCaptain
DBguy,
That did the trick. Thanks again for your help.
TheCaptain
theDBguy
You're welcome. Glad to hear you got a solution. Good luck with your project.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.