Auto Sort in a Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which contains a subform...pretty basic...except when I enter
information in my subform and then preview the information it sorts the
multiple fields of information. Is there a way I can prevent sorting to this
subform so that however I enter the information that it will appear on my
form/report as I entered it.

Any help would be appreciated.

Thanks Bunches!!!!
 
Crystal T said:
I have a form which contains a subform...pretty basic...except when I enter
information in my subform and then preview the information it sorts the
multiple fields of information. Is there a way I can prevent sorting to
this
subform so that however I enter the information that it will appear on my
form/report as I entered it.

Any help would be appreciated.

Thanks Bunches!!!!

You would need to add some sort of sorting field to your table (that the
subform is based on), because there's no way to guarantee the sort order
without a field to sort on. Order of entry won't necessarily be the sort
order.

Carl Rapson
 
HI Crystal

You could base the subform on a query and sort the query as you wanted. If
for example you need to sort by surname then your would sort this column in
the query and this would affect the sorting when you opened the form.

I assume you hav an autonumber primary field in the table the form is based
on. So if you sort the query by this then the records will be sorted as you
entered new records.

Of course this will not take affect until the form is either reopend or
requeried. but in general it will will give the effect you are looking for.

HTH
 
One way would be to add a date field in the db and set the default value to
Date(). Base you sort query for the form on that date field. You do not
need to have the new field visible in the form.
 

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

Back
Top