Tech Support Guy banner
Status
Not open for further replies.

Solved: Access 2010 Forms

3K views 4 replies 2 participants last post by  HiTechCoach 
#1 ·
Hi there,

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.

Please let me know. Thanks!
 
#2 ·
Just to expand on my initial post & give some visuals:

I have a textbox in my form called Barcode, http://i55.tinypic.com/kby70i.png, that is generated by the equation =[PurchaseOrderNumber] & [PartNumber], http://i52.tinypic.com/2edun0n.png.

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:

http://i55.tinypic.com/kby70i.png

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 hope that this further explanation will help!
 
#3 ·
I really see no valid reason for storing the calculation of [PurchaseOrderNumber] & [PartNumber].

It is possible to search on the calculated data. One option is to do the calculation in a query.

In a query you could use this SQL to calculate a field:

Code:
[PurchaseOrderNumber] & [PartNumber] as PartBarCode
This could also be used to populate a combo box.

Boyd Trimmell
aka Hi Tech Coach ( HiTechCoach.com free Access stuff)
Microsoft MVP - Access Expert

Business Process Management - Accounting/CRM Software Developer
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top