Select a component of subform on ACCESS
Posted on 2011-09-08
I am currently beginning on Access/VB.
I am working on a formular which includes a list and a subform.
Basically I type year on a textboxt and the subform shows the list of course beginning at this year after cliking on a button. (table course have an ID, description and Year item)
I think it's something like writting in the button click event function like:
"Me.Form .." but i dont know more.
the "algorithm" is simple:
1)get the year from the text box
2)use this for making a sql request in the subform
I have no idea of the syntax even for 1 and i dont know how to apply SQL request to form (after storing it in a String), could you give me some clues?