Hi - I feel this is easy but rather complicated to explain.
firstly, I'm using Access 2010.
I have two tables called tbl_contacts & tbl_questions
I have two forms called frm_questions1 & frm_questions2
The record source for both the above forms is from tbl_questions. At the top of the form, I've got a section for 'Contacts'. This basically allows me to choose a name from a drop down box and it automatically completes all the other fields about this person that are stored in the 'tbl_contacts' table. This way I don't have to type the persons details in each time.
As mentioned above, I've created two forms. 'frm_questions1' & 'frm_questions2' that share the same record source. (It's important they are in two separate forms which look different from one another).
On the first form 'frm_questions1' I have two buttons which say;
- 'Click here to complete questions 1'
- 'Click here to complete questions 2'
I would like to have a status appear underneath these buttons that show if these forms have been completed or not.
So, if all the values in question 1 get completed it will display a label under this button for 'Questions 1', saying 'Complete'. If the questions haven't been started or are incomplete, then it will display a message saying 'Incomplete'.
The same applies for 'Questions 2'.
If you're able to give me an example to which I can tweak for my own application that will be very helpful.
Hope this makes sense. Happy to clarify more...