retain obsolete part information in quotation but not in combo box

[ChrisA]

We are creating quotes based upon a selection from a combo box using the
following row source

SELECT AtlasProducts.ProductNo, AtlasProducts.ProductName,
AtlasProducts.ProductID, AtlasProducts.Obsolete
FROM AtlasProducts
WHERE (((AtlasProducts.Obsolete)=False))
ORDER BY AtlasProducts.ProductNo;

The bound column on the combo box is is the ProductID which is the primary
key for the AtlasProducts table.
The combo box shows to the user the ProductNo.

When I mark a product as obsolete the combo box no longer shows the product
in the listing as expected but the legacy record in the quote form does not
show the ProductNo in the combo box field as before. Obviously because it is
no longer in the record source. Hope someone can suggest how I get around
this.

Thanks
Chris

 

[John Vinson]

When I mark a product as obsolete the combo box no longer shows the product
in the listing as expected but the legacy record in the quote form does not
show the ProductNo in the combo box field as before. Obviously because it is
no longer in the record source. Hope someone can suggest how I get around
this.

The only way I've found is to put a Textbox on the form bound to the
ProductNo field. Carefully superimpose it over the text area of the
combo box; set its TabStop property to False, Enabled to False, and
Locked to True so the user can't do anything with it except see it.

The combo's list will appear when the combo dropdown is selected, but
otherwise you'll see the actual table content (obsolete or not).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps