VB result into a Query (1 Viewer)

[wizcow]

I have a bit of code that calculates the InStockQuantity of a part.
This works okay in my parts form.

On my Invoice form I have a PartNo combo box that is fired by a query that looks up the part information.
The pull down list has several columns, PartNo, StoreNo and Description.

I would like to have the InStockQuantity in this list too.

How can I get the code result to appear in the combo box pull down list?

Thanks
Tom

 

[dcx693]

I would like to have the InStockQuantity in this list too.

Base the list rowsource on a query that has the InStockQuantity field in it. Can you calculate that on your query? You should be able to since you are able to do it on your form.