This should be fairly easy (unless you are new to Access like I am), I have 4 Toggle Buttons in a OptionsGroup called "SortBy", which (surprisingly) all I want to do is have the form sort on the four different fields/columns. Please help when you getr a chance - tks ;-)
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
AlSaul
- Thread starter AlSaul
- Start date
MichaelRed
Programmer
To actually get some concerte HELP w/ this you will need to sypply some additional detail.
Generally, to "sort" a form's records implies sorting the recordsource in some manner - and then refreshing the form.
Other situations are possible.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
Generally, to "sort" a form's records implies sorting the recordsource in some manner - and then refreshing the form.
Other situations are possible.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
hermanlaksko
Programmer
You could try this
me.recordsource="Select * from yourtabel order by yoursort"
Place this on the after update on your optionsgroup.
Should do the trick.
If not Grrrrrrrrr.... ;-) let me know on mb@wfbutik.dk and I will se what I can do.
me.recordsource="Select * from yourtabel order by yoursort"
Place this on the after update on your optionsgroup.
Should do the trick.
If not Grrrrrrrrr.... ;-) let me know on mb@wfbutik.dk and I will se what I can do.
- Status