trouble sorting-

M

Maggie

hello,
I have a form with a subform.The subform has a date field (short) in it. the
subform shows a list of entries by date. The problem is that the new entry
with today's date in it, shows up at the bottom instead of the top. I tried
to sort on the date field, but it doesn't work- even if I base the subform
off of a query or a table.I know there's probably more than one solution, but
what is the simplest ? I thought of putting another subform in there with
only the empty entry first. But that seems kind of hokey. i also tried adding
another field altogether to sort on that, but that didn't work either - that
last emtpy entry shows up at the bottom! arghhhh!!!!!
Any ideas?
thanks-
 
M

Marshall Barton

Maggie said:
I have a form with a subform.The subform has a date field (short) in it. the
subform shows a list of entries by date. The problem is that the new entry
with today's date in it, shows up at the bottom instead of the top. I tried
to sort on the date field, but it doesn't work- even if I base the subform
off of a query or a table.I know there's probably more than one solution, but
what is the simplest ? I thought of putting another subform in there with
only the empty entry first. But that seems kind of hokey. i also tried adding
another field altogether to sort on that, but that didn't work either - that
last emtpy entry shows up at the bottom! arghhhh!!!!!
Click to expand...


Access forms always have the new record at the bottom. Your
hokey idea is the usual approach if you must have it at the
top.

Most people live with it at the bottom and just move the
cursor to the new record:

If Me. Recordset.RecordCount > 0 Then
DoCmd.RunCommand acCmdRecordsGoToNew
End If
 
P

Peter Yang [MSFT]

Hello,

Yes, as Marsh mentioned, there is no avaliable method to move the new
record to the first one. You could move to a new record on it with the
following code in the Click event procedure of a button on the parent form:

Me.RedSub.SetFocus
DoCmd.GoToRecord, Record:=acNewRec

Or you can put it in the parent form's Current event procedure so that it
moves there automatically when you navigate to a record in the parent form.

I do understand your concern in this scenario,and please rest assured your
feedback on this feature is routed to the proper channel. Also, I suggest
you can
submit this feedback to our product feedback center so product team may
hear your voice:
http://www.microsoft.com/office/community/en-us/wizard.mspx?type=suggestion&
lang=en&cr=US&cat=en-us-office&pt=3a4e9862-cdce-4bdc-8664-91038e3eb1e9

If you have further quesitons or concerns, please let's know. Thank you!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Top