Option Buttons

[Guirg]

Hi

So it turns out that my supervisor wants buttons and more buttons and more buttons to be able to search.... I managed to get a search box working but apparently he wants to be able to choose a label and then type in a max value and a min value range and search with in that... i was thinking is is possible to have an _click sub set up for a whole bunch of option buttons and limit it to only having one selected at a time?? and with the selection then go to another sub ... where i have an if statement for the two text boxes where the max min values would go in??

cheers

Guirg

 

[DCrake]

Alot will depend on what type of data he is searching/filtering. Remember whatever they type in has to be a valid format to match the type of data they are searching for. So for example, if you want a date range it is best to have two distinct fields which have an input mask and defined as date fields. this will prevent the user from entering spurious dates such as the 31st June.

David

 

[Guirg]

i was hoping to have 2 unbound text boxes as the input and my supervisor would have to have the input in properly as the fields are already formated into date, double, text or whatever.... which is why i was hoping to have option buttons and restrict the selection to one, or else id end up with 60 unbound text boxes for all the fields he can select from.... not sure how to start the coding for it tho

 

[timothyl]

Guirg, maybe this will help, it would take a little reworking. I have used it as a foundation for a searh tool a number of times.

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=12024&d=1135634856

 

[Guirg]

cheers for that, i had a look at it yesterday the only problem im stuck now on is when an option button is selected how do i assign the column to then search?