Sorting Records from ComboBox

[aquanova]

I'm working on Microsoft Access. I have a form which views the record of one table. Inside the form, there are several columns. Now I want to sort the records with using combobox. Eg. if the value of the combobox is "Date" then the record is automatically sorted by date itself, if "Name" if chosen then the form will be sorted based on the name...

I'm new to VBA but I've done several SQL...
Thank you...

[CaptainD]

Is the form bound or unbound to the database?

If it's unbound, you can set up your query where the order by clause is set by the combobox value.

Select case combobox.text
Case "Date"
sOrderBy = "Order by [Date] ASC"
Case "Last Name"
sOrderBy = "Order by [LName] ASC"
End Select

sSelectString = sSelectString & sOrderBy