Unanswered: Creating the primary key based off of non-key values in a form
I am using Microsoft Access 2007. I created a form to add parts to the part table. The [PartNumber] which is the primary key for the table, is suppose to be composed of different values. The first of which is the [PartDesignation], which is the series.
So to start out, I just want to place the value the user enters in the [PartDesignation] field into the [PartNumber] field. Later on I will concatenate other values that make up the part number, but for right now I just want to get one single value to go in there.
Any help would be appreciated!
Option Compare Database
Dim partNumberString, seriesDesignationString As String
Private Sub Form_AfterUpdate()
partNumberString = seriesDesignationString
Me.[PartNumber].Text = partNumberString
Private Sub PartDesignation_AfterUpdate()
seriesDesignationString = Me.[PartDesignation].Text