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.