We help IT Professionals succeed at work.

MS ACCESS 2003 :  Can I do a sort-order hierarchy in my form?

R B
R B asked
on
I have a form - where I want the data-columns to populate by:  Office, then by Type (Personnel , Non-Personel), and then the Account (ascending order)

Where can I specify this?

Also - Can I make a pop-box ask for me to enter the "office" that I want the form to open-up for?   Currently - this form is running from a "table".   I can't base the Form on a Query - as it has too many joints where it will next not allow me to enter data into 3 new columns that I need to populate....

Currently - I run the make-table query - for all of my offices - and wish to next utilize my form - to input data by office - as the need arises.
Comment
Watch Question

Commented:
>I have a form - where I want the data-columns to populate by:  Office, then by >Type (Personnel , Non-Personel), and then the Account (ascending order)
>Where can I specify this?

Change the recordsource to a query:

Select * from YourTable order by Office, Type, Account


>Also - Can I make a pop-box ask for me to enter the "office" that I want the form >to open-up for?  

Yes.  But most designers opt for a ComboBox which allows the office to be selected by name and then requeries or filters the form based on the selected office.


>Currently - this form is running from a "table".   I can't base the Form on a Query - as it has too many joints where it will next not allow me to enter data into 3 new columns that I need to populate....

The limitation is not Table vrs Query.  The limitation is the complexity of the relationships that you establish in the query.  The query is not updateable because it's logically ambiguous to change one or more fields.


>Currently - I run the make-table query - for all of my offices - and wish to next utilize my form - to input data by office - as the need arises.

And then somehow get data back into the original tables????????

I suggest you consider a different design.

1.  Base your main form on the non-updateable query.
2.  Do your updates on a subform which updates the original table.


 
R B

Author

Commented:
thank you