B
BRC
Hi all,
I have a form that contains order info with subform (datasheet view)
that contains order detail. In the itemname combo box of the subform
the user can select the item name. The combo box rowsource is the
itemsQ and the Control source is the ordersDtlQ (itemname) field. I
have a field in itemsQ query called subcat which is a subcategory
field . Here is what I am trying to do. When the user enters a new
item in the table user can decide to make item a sub categoring of
another record. The default subcat is the itemid if no subcat is
assigned. Lets say the user selects "wrench" in the itemnamecb. The
combobox checks to see if there is more then 1 item with the subcat
wrench. If dcount finds subcat >1 it will display a popup form showing
all items that are subcat of "wrench". Eg, lug wrench, allen wrench,
wrench Monkey, etc. from the pop up the user can select the specific
wrench he/she wants and click on it. Then I want to populate the
itemnamecb on the calling form with the value selected from the
popup. I have everything working up to passing the value from the
popup back to the calling combobox. I tried assigning the value on
the click event of the popup but I keep getting "item does not exist
or is closed" error mess. Sorry for the long post but hard to
explain this in 3 sentences. Thanks for any advise or direction.
thanks BRC
I have a form that contains order info with subform (datasheet view)
that contains order detail. In the itemname combo box of the subform
the user can select the item name. The combo box rowsource is the
itemsQ and the Control source is the ordersDtlQ (itemname) field. I
have a field in itemsQ query called subcat which is a subcategory
field . Here is what I am trying to do. When the user enters a new
item in the table user can decide to make item a sub categoring of
another record. The default subcat is the itemid if no subcat is
assigned. Lets say the user selects "wrench" in the itemnamecb. The
combobox checks to see if there is more then 1 item with the subcat
wrench. If dcount finds subcat >1 it will display a popup form showing
all items that are subcat of "wrench". Eg, lug wrench, allen wrench,
wrench Monkey, etc. from the pop up the user can select the specific
wrench he/she wants and click on it. Then I want to populate the
itemnamecb on the calling form with the value selected from the
popup. I have everything working up to passing the value from the
popup back to the calling combobox. I tried assigning the value on
the click event of the popup but I keep getting "item does not exist
or is closed" error mess. Sorry for the long post but hard to
explain this in 3 sentences. Thanks for any advise or direction.
thanks BRC