multi combo issue

[Lez]

Hi Guys,

I have a combo box to list products, I have 3 further combo's that are used
for color, size, and other.

My first combo box control source is the prodID, however the option of this
product is selected by the manRefID

I have tried:

[Forms]![TestLineitems]![cbo0].Column(2)

to see if I can trap the ManRef, which fails asking me to enter a parameter

I have also tried adding a hidden text box to trap the manRef, which gets
the value, however the combo box then only gets the value from the first
text box

Can anyone suggest anything else I can try?

 

[Chegu Tom]

Hi

Just a guess here.

Are you looking for the second column in your combo box query? The column()
property starts from zero as the first column

Try [Forms]![TestLineitems]![cbo0].Column(1)

 

[Lez]

Thanks for that, no, I am aware of the numbering, it is the that prodID is
the PK and I need to use manRefID

Hi

Just a guess here.

Are you looking for the second column in your combo box query? The
column() property starts from zero as the first column

Try [Forms]![TestLineitems]![cbo0].Column(1)

Hi Guys,

I have a combo box to list products, I have 3 further combo's that are
used for color, size, and other.

My first combo box control source is the prodID, however the option of
this product is selected by the manRefID

I have tried:

[Forms]![TestLineitems]![cbo0].Column(2)

to see if I can trap the ManRef, which fails asking me to enter a
parameter

I have also tried adding a hidden text box to trap the manRef, which gets
the value, however the combo box then only gets the value from the first
text box

Can anyone suggest anything else I can try?

 

[Chegu Tom]

Lez

Please post the rowsource for cbo0

Where are you using [Forms]![TestLineitems]![cbo0].Column(2)? Is it part of
the rowsource for another combo box?

Post that rowsource as well.

Tom

Thanks for that, no, I am aware of the numbering, it is the that prodID is
the PK and I need to use manRefID

Hi

Just a guess here.

Are you looking for the second column in your combo box query? The
column() property starts from zero as the first column

Try [Forms]![TestLineitems]![cbo0].Column(1)

Hi Guys,

I have a combo box to list products, I have 3 further combo's that are
used for color, size, and other.

My first combo box control source is the prodID, however the option of
this product is selected by the manRefID

I have tried:

[Forms]![TestLineitems]![cbo0].Column(2)

to see if I can trap the ManRef, which fails asking me to enter a
parameter

I have also tried adding a hidden text box to trap the manRef, which
gets the value, however the combo box then only gets the value from the
first text box

Can anyone suggest anything else I can try?

 

[Lez]

Hi Tom,

I have sorted the rows out now and got the form working ok. What I did was
to add a hidden text field bound to SKUID on the form and for cbo0 added the
following after update event:

Me.quote_line_SKUID = Me.txtSKUID
Me.cboColour = Null
Me.cboColour.Requery
Me.cboSize = Null
Me.cboSize.Requery
Me.cboOther = Null
Me.cboOther.Requery

So the row was now bound to manRefID

For each of the cbo's I added the following to the manRefID

Like [Forms]![frmOrderlineitems].[Form]![cboProduct]

Which worked fine, however, as this is the line items of the main form
order, when it becomes a sub form I have to modify the condition to:

Like [Forms]![frmOrder]![frmOrderlineitems].[Form]![cboProduct]

This does not work though and fails presenting a parameter box for the
value, I gather I am not referencing the form correctly. if you can advise.

Regards
Lez

Lez

Please post the rowsource for cbo0

Where are you using [Forms]![TestLineitems]![cbo0].Column(2)? Is it part
of
the rowsource for another combo box?

Post that rowsource as well.

Tom

Thanks for that, no, I am aware of the numbering, it is the that prodID
is
the PK and I need to use manRefID

Hi

Just a guess here.

Are you looking for the second column in your combo box query? The
column() property starts from zero as the first column

Try [Forms]![TestLineitems]![cbo0].Column(1)




Hi Guys,

I have a combo box to list products, I have 3 further combo's that are
used for color, size, and other.

My first combo box control source is the prodID, however the option of
this product is selected by the manRefID

I have tried:

[Forms]![TestLineitems]![cbo0].Column(2)

to see if I can trap the ManRef, which fails asking me to enter a
parameter

I have also tried adding a hidden text box to trap the manRef, which
gets the value, however the combo box then only gets the value from the
first text box

Can anyone suggest anything else I can try?