Hi, please could someone answer a question for me?
I have created a form to collect data accessed by a button on a switchboard. The problem is the form really neads to be split into two sections. The first half is to be filled in by one person in the office and saved. Later a second person needs to go into the same form and fill in the second part of it then save the completed form.
Is there a way of setting it up with two control buttons on the switchboard so then when the first person clicks on the first button only the first half of the form is visible, the rest hidden. He can then fill in his part and save it.
When the second person then clicks on the second button the same form opens but with the second half of the form vissible and the first half hidden. He can then finish off the form then save it.
Iwill also need the first button to open the form as a new record and the second button open the form as the last record..
Any Ideas, or am I flogging a dead horse here.
Hope you can Help, Andy