How To Sort A Number Field in a Form?

[netchie]

Hi,



I have a form where data can be added and it has different tabs. The 3rd tab has idVersion field and Comment field where users can add the version and comment, if needed. When they need to add another version, the blank fields will be added as next row, so on and so forth. The problem is users are adding a lot of versions but not sorted. So for example:

Row 1 of the form: idVersion field is "1" and comment has "Test 1".
Row 2 of the form: idVersion field is "8" and comment has "Test 8".
Row 3 of the form: idVersion field is "2" and comment has "Test 2".
Row 2 of the form: idVersion field is "5" and comment has "Test 5".


So how can I fix it where after they saved the version and comment, when they close the database and re-open it again, the data will show up as:

Row 1 of the form: idVersion field is "1" and comment has "Test 1".
Row 2 of the form: idVersion field is "2" and comment has "Test 2".
Row 3 of the form: idVersion field is "5" and comment has "Test 5".
Row 2 of the form: idVersion field is "8" and comment has "Test 8".


So even if they add a new version and comment (example version "3"), it will be automatically sorted when the database is reopen.

Thanks in advance,
netchie

[ssanfu]

What is the record source of the form?

[netchie]

It is tblModelVersion

[ssanfu]

To sort (or order) records, you have to use a query. Tables are just "bit buckets".
Create a query (qryModelVersion), add the fields, select which field(s) you want to sort by, save it, then change the form record source to the name of the query. All controls should stay bound to the field.
The order of the fields in the query doesn't matter - if you have multiple field to sort by, you can rearrange them to get the fields in the order you want.

[netchie]

Ok, I already created a query for it and drag all necessary fields that I need. I changed the Control Source to the new qry that I created. I checked it out but some are still not sorted. Well, actually, I created a query and use it that's all and did not do anything on how to show that it's sorted. So how can it be sorted?

[netchie]

I put "Ascending" in Sort and it worked!

Thanks ssanfu!

[ssanfu]

You are welcome