Subform query

[solargovind]

Hi,

Can anybody suggest me how to call Subform/Main form's control in query...?

For example, I have Two combo box in Mainform.

If i select Student_roll_No in one combo box, in other combo box i need to display their marks,total,grade etc., which has been called by query. This combo box has 7 coloumn heads which can display all the details.

How could i display 2nd combobox query list based on the first combo box..?

Assume the above case..
- If the 2nd combo box is in Main form.
- If the 2nd combo box is in Sub form.

Pls.suggest me.

Thanks in advance.

ngr.

[Rabbit]

To refer to controls on subforms, the format is:

 Within VBA Code
Me.SubformControl.Form.ControlName
 
 Absolute Path
[Forms]![MainForm]![SubformControl].Form.ControlName
 

[JConsulting]

in the after update event of combo 1, using whatever field you use to link the records (I used ID below) also, this assumes that ID is column(0) in combo 1 and it numeric

dim strSQL as string
strSQL = "select * from yourtable where ID = " me.combo1

if combo2 is on the same form

me.combo2.rowsource = strSQL

if combo2 is on a subform

me.subformname.form.combo2.rowsource = strSQL

J