sorting in subForm

K

KarenY

I have this "Order By" properties in my subForm, and it has been working very
well in the DataBase :
[02RecordPartsLength].[Date(mm/dd/yyyy)] DESC

This subform was created from a table. It is for the personnel to enter the
data by date. The idea is for people to view the latest date on the top when
the Part Number has been selected (searched in the Mainform). The subform
opens at the bottom of the main form carrying all the dates of the data-entry
of the part number. The mainform was from a table which carries all the
partnumbers (no duplicates).

Quite some time ago, the sorting doesn't work anymore, I have no idea what
went wrong. For now, I just ask the colleagues to click "sort descending" by
the field "Date(mm/dd/yyyy" manually.

The "Order By" properties in the main Form is:
[01measurePartsOHTab].[ID] ASC

Yet I don't think the "Order By" in the main form affects the problem I have.
I have tried to remove the "order by" in the mainform already, the sorting
in the sub-form still doesn't work either.

I would appreciate if somebody could help me out.
thanks
Karen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Populate main form from subform record 0
Forcing a date entry format of dd/mm/yyyy 1
Unremovable horizontal scroll bar on subform 1
Subform 7
data entry in subform before mainform causes huge hassle, HELP! 2
Publisher is filling blank lines with data 2
Counting in Subform 3

Top