Open another form and show same unique ID
Posted on 2013-12-04
Hello - I use Microsoft Access 2010 and I have two tables (tbl_personaldetails & tbl_questions) I also have to forms (frm_questions1 & frm_questions2).
Both forms share a unique number called 'PersonalID'. This does not use the Primary Key and it is related to this particular person.
I have a button on both my forms called 'View Question 1 Responses' & View Question Two Responses'.
Basically, there are two forms for two sets of questions. The first form with the first set of questions has 15 questions and the second form has about 10. The second form which shows the second questions are basically a follow up from the first set of questions to see if they've improved since they were first asked.
I need a way for the user to click the button 'View Question 2 Responses' and it opens up the second form 'frm_questions2' and takes them to the same person by their unique ID which uses the field 'PersonalID'.
Ideally, It'd work best that the button wasn't available unless there were questions answered in the second form from this particular person. If they've not answered the questions in the second form yet, then the button could either be grayed out or invisible. If there were questions answered, then it would be visible and the user could click on it. It would be used for a quick way to compare their answers from both forms.
Hope you can help.