sorting addresses

  • Thread starter Thread starter judith
  • Start date Start date
J

judith

I have an address field which is text, it can be numbers
1, 12, 111, 1B, 23A, Flat 34, Flat K, grounf Floor Flat.

I set the form (continuous) up on a query and by creating
a sort field with a combination of in-filling with blanks
managed to get the sort order working perfectly.
However the form became very unstable so i set it back to
the table base. But now I am having problems sorting the
form as my calculated field is not created before the
sort occurs? I suspect that this is why my query based
form was becoming unstable.
Any suggestions please
 
There's no reason that a form should be any less stable if it's based on a
query rather than a table. (I never base any forms or reports on tables).

I suspect there's something else that's causing your problems, but you
haven't given us enough to go on.
 
I am sure you are right that it is the system rather than
this particular form. The system consists of a form with
tabs and sub forms with tabs that are all displaying
different views of parts of the database and some show
overlapping data. However just flipping this particular
form from the query to the table has stopped the system
throwing me out. The only thing I did in the query was to
create a field which I use for sorting

IIf(Len([Address1])=1,(" " & [address1]),IIf(Len
([address1])=2,(" " & [address1]),[address1]))

I then created this as a field in the form based on the
table and was unable to even use the AtoZ sort button
from the toolbar. Is it just forming some type of loop?

Thanks
 
Back
Top