I get a compile error when I try this same thing
error: Method or data membr not found
Private Sub Form_Load()
Me.TabCtlName.Pages(0).SetFocus
End Sub
it hilights .TabCtlName.Pages(0).SetFocus
I am using Access 2002
Ok the questions them selfs are stored as lables on the form it's self.
Then there is a field for the yes/no/na checkbox and a field to store the answer(note) for each question.
I only have 2 fields for each question, a field to hold the check box field for a yes/no/na answer and a field to hold a note to each question. it sounds like this is a normalized data base to me. The problem is the number of question that there are.
I have a question/Answer type of data base. One field is a yes/no/na check box and the other is notes fieled. There are over 300 questions and 300 note fileds. This is for an audit compliance review.
I have reached the maxium fields for a table but still need to add more. How do I link the tables togather so one is a continuation of the other for reports.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.