Subform Sorting

[edisonl]

Hi (appreciate if someone can provide some suggestion),

SITUATION:
1. I have main form that contain subform.
2. Subform generates display of an APPEND QUERY.

PROBLEM:
3. Though in my query I set sorting (using one of the field- Sequence in asending order), only 85% of time data display is accurate.
4. To be more precise, Query able to generate out data accordingly, but subform not really displaying according to Sequence(Eg: 1-5, at times it goes 4,5,1,2,3)

ALTERNATIVE:
5. Tried checking the origin table where query extract data from nothing was wrong in the field-Sequence.

6. What could possibly be the problem?

7. Thanks for reading my thread though.

Regards & God Bless

 

[boblarson]

A couple of questions -

1. You say it displays an Append query, but the recordsource of a form cannot be an action query, it needs to be a select query.

2. what is the datatype that you are sorting by?

3. What is the SQL of the query you are trying to use?

 

[edisonl]

Hi Bob,

1. Thanks for replying.

2. Pardon me, but my subform recordsource is a select query.

3. Sorting a numerical value integer.

4. don't really get what you mean SQL of the query ?

 

[boblarson]

4. don't really get what you mean SQL of the query ?

When you go into the query in design view, go to the VIEW and select SQL. Copy the entire statement -

SELECT xxx FROM XXX WHERE XXX = XXX ORDER BY XXX;

And paste it here.

 

[edisonl]

Hi Bob,

1. Think is data type declaration error, record source-Seq= Integer
2. Destination Table-Seq= Long Integer
3. Will do few trial run & see if as suspected.
4. Wish me luck.

Regards & God Bless

 

[edisonl]

Oh No, Error Again

Hi Bob,

1. The same error occurred in the case of previously mention Appearance Sorting Error.

2. However this occured only once in about 100 time? 1% chance, but I can't afford it.

3. Was Thinking: Maybe if I do another Query to the destination table to Re-Sort again, will it works?

4. However what concerns me was that: After I Docmd.appendquery, next line I do another Docmd selectquery, will it impact on implicates hidden issues ?

Regards & God Bless, Edison