Is a combo box really this hard?

[DaveMac]

I should know this but I don’t. I have a combo box that is on a subform. The Combo box is sourced from a query of Partnbr, Description from tbl_parts

I can get partnbr into tbl_needed_items(the source for the sub form)

When I use:
Me!Description = DLookup("descp", "qry_all_skus")

I get the same description on every line of the subform.

 

[DaveMac]

that is in the after update of the prodno_combo

 

[dhookom]

What are your significant tables and fields?

It looks like you are attempting to store the description value in more than one table. This is not recommended.

Your DLookup() doesn't contain any where condition (third argument).

If you want to display the description in the subform, set the control source of a text box to:

=cboPartNbr.Column(1)

where cboPartNbr is the name of your combo box and 1 is the second column in the combo box row source.

Duane
Hook'D on Access
MS Access MVP

 

[DaveMac]

Thanks that got it. I thought I tried that already but maybe not. Thanks for the help!