I have a subform within a form that contains a field with the control source =[PurchaseOrderNumber] & [PartNumber] which basically puts two fields together to create a barcode. I would like for this value to be saved into a field in a table.
Does anyone know how I would go about doing this? I have searched for solutions & have found none.
I'm attempting to have the values that are calculated in the Barcode field saved into a Barcode field in the Purchase Orders table. http://i52.tinypic.com/2e4kuo7.png
The reason for doing this is because I would like to input a combo box to search through the barcodes to filter the purchase orders for a specific barcode as shown in the bold black box in the image below:
The primary issue is that I have no clue how I would do that. However, there is also another problem. Even if the first issue is resolved, we have to keep in mind that there can be multiple items within a purchase order, & they would each have their own unique barcode, http://i56.tinypic.com/24o7fyw.png. Therefore, we can't simply input one barcode for each purchase order.
<< I managed to use an update query to do it for me.>>
Hope that does not mean you are storing the calculation.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!