Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create an Option Box or Validation?

Status
Not open for further replies.

burcher

Technical User
Apr 26, 2004
22
0
0
US
I have a continous form that has 3 fields,
Begining Date, Ending Date, and a check box for selected. I have a global function (thanks to Bob Scriver) that will read what the beginDate and EndDate are from the TimeTbl and filter different forms.
Is there a way to make this form act like an option box so that there is always only 1 field that can be checked,(if one is checked and you check on a different one, it will uncheck the checked one and check the new one). Cause big problems begin happening if there is none checked. Or can I use some kind of validation rule?
Whats the best way to proceed?
 
Does anyone know if it is possible to use a validation rule or option box? or will it require VB coding?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top