VB code for docmd.

[rajikasimu]

Hi, Friends,
I am developing a simple package as a leaner in Access, I have a form(named Admin2) displaying two fields namely USERNAME and PASSWORD from a table named MASTER. i have another form namely Changer1 with a combobox named combo10 displaying the field username from the table (MASTER) and a command button. i want anytime I select a username from the combo and click on the command button to open the form (Admin2) with the selected value of the combo.
I have this code at the click_event of the CommandBttn
DoCmd.OpenForm "admin2", , , "userName = & Me.Combo10.Column(1)"
it give me syntax error(missing operator) in a query expression
please help

[pbaldy]

Close:

http://www.baldyweb.com/wherecondition.htm

[rajikasimu]

Thousands of thanks to you guys especially Pbaldy, your codes really solve my recent problem.

[pbaldy]

Happy to help!