aussie_user
Registered User.
- Local time
- Today, 13:20
- Joined
- Aug 6, 2002
- Messages
- 32
Hi,
I have a table of Organizations that I use a 5 letter code for the ID field which is the Key Field. I have a query on the Organization table and from that I built an Organization Form to make entering the information easier. The 5 letter code usually involved the initals of the organization and thus keeps records in an alphabetical order. For some reason my form keeps ordering the records in the order I entered them. This causes problems when I want to check to see if an organization has been entered (there are approximately 200 records at the present time). I usually have to close the form, and scroll through the table. I've looked at the properties of the form but can't see any way to set the order on it. I even deleted the form and recreated it using the wizard and I still have the problem with the order. Can anyone tell me how I can get the form to show the records in order by the OrgID field? Thanks.
I have a table of Organizations that I use a 5 letter code for the ID field which is the Key Field. I have a query on the Organization table and from that I built an Organization Form to make entering the information easier. The 5 letter code usually involved the initals of the organization and thus keeps records in an alphabetical order. For some reason my form keeps ordering the records in the order I entered them. This causes problems when I want to check to see if an organization has been entered (there are approximately 200 records at the present time). I usually have to close the form, and scroll through the table. I've looked at the properties of the form but can't see any way to set the order on it. I even deleted the form and recreated it using the wizard and I still have the problem with the order. Can anyone tell me how I can get the form to show the records in order by the OrgID field? Thanks.
