Hey
Thanks for taking the time to read, my first question is can Access Forms do what I need to do, namely:
I need to capture Location which is broken down into segments, Site / Block / Floor / Room, If I have dropdowns in a form, can I have it so that if Site A is selected, only Site As Blocks are available in the Block dropdown, if Block 1 (site A) is selected then only Site A, Block 1s Floors are visible in the Floor drop down and so on
and also, i would like 2 buttons, Save and New - saving the current submission and clearing the whole form for a new entry, and Save and New (Same Location) - saving the current submission and clearing all fields except the location fields in the instance of repeated submissions against the same location.
Thanks again for reading!
Jason
Thanks for taking the time to read, my first question is can Access Forms do what I need to do, namely:
I need to capture Location which is broken down into segments, Site / Block / Floor / Room, If I have dropdowns in a form, can I have it so that if Site A is selected, only Site As Blocks are available in the Block dropdown, if Block 1 (site A) is selected then only Site A, Block 1s Floors are visible in the Floor drop down and so on
and also, i would like 2 buttons, Save and New - saving the current submission and clearing the whole form for a new entry, and Save and New (Same Location) - saving the current submission and clearing all fields except the location fields in the instance of repeated submissions against the same location.
Thanks again for reading!
Jason