Newbie form question.. please help

[Tinku]

I have 2 forms.

The 1st form has 2 comboboxes. The row source of the 1st Combo box is table "A" and Rowsource for Combo Box is Rowsource Table "B".
The table "A" has 18 fields. And Table "B" has only one field.

The 2nd form has 6 text boxes. I want to display results in my 2nd form based
on the selection from 1st form.

I want to be able to select which columns I want from Table "A" based on the selection from 2nd Combobox and assign them to the 3 unbound textboxes in the 2nd Form.

Hope this makes sense.

Regards
Tinku

 

[WayneRyan]

tinku,

Hard to do this from the info, but something like the following.

Use the AfterUpdate event of your combo:

Forms![FormB]![txtBox1] = Me.Controls(Me.Combo.Column(0))
Forms![FormB]![txtBox2] = Me.Controls(Me.Combo.Column(1))
Forms![FormB]![txtBox3] = Me.Controls(Me.Combo.Column(2))

btw,

Why an unbound form? I hope you get really good at code, because
you'll be seeing a lot of it.

Wayne

 

[Tinku]

Hi WayneRyan

Sorry, I know this is hard to explain.
Can I send you my mdb file so you can have a look at it ?
Any email address ? I really appreciate all your help.

Regards
Tinku