Access VBA Help

[vvasudev]

Hello,

i am new to working in access enviroment, well i wanted to get aquainted with the controls. Well i have a from which has 1 Combobox, 1 Button and 1 Textbox

Well i want to write a select statement in the VBA editor and would like to display the answer in a textbox. A sample of the sql statement is below

"Select S.Mark1 from Student S where S.Name = '" & ComboBox1.Text "';"

I know this is a very very basic question but as i have already mentioned i am new to working in the access enviroment. I need to know the entire syntax for this including the connection strings

Cheers,
Vineeth

 

[zeukzir]

hi vvasudev

i'm new here and my english isn't very correct, but i think you are looking for is that

(in the button click event)
me.myTxtBox=me.myCboBox.column(1)
note that the first column in the combobox is 0 and the second is 1, 2, etc.