
February 8th, 2006, 05:47 AM
|
|
Registered User
|
|
Join Date: Feb 2006
Posts: 4
Time spent in forums: 26 m 13 sec
Reputation Power: 0
|
|
|
Accessing fields in Continuous forms in VBA
Hi Guys, (I also posted this in the DB forum, but as the code will be in VB i thought id post it here aswell  )
I currently have a subform which relates to the primary key of the main form.
This subform contains possible 'Answers' which related back the main form/table 'Question'. Each possible answer has a true of false field to show whether or not it is the correct possible answer from the question field.
Currently the subform performs correctly, in that it shows up the 3 possible answers for each question... (in continuous form view)ie all three appear at once in 'form view' - but in the subform the only one answer and one true or false attribute appear at once.
Here is where the problem is - i need to be able to access the individual field values for these 3possible answers (in VB code). I cant work out how to do this? Does anyone know how access calls them? What will the checkboxname be? The problem is because there is only one checkbox on the form in 'Design View' (to see if the answer is the correct one), but then 3 in 'Form View', I cant work out how access distinguishes between them.
Many thanks
Ross
|