I am building a database to keep track of orders requested from our warehouse. I have most of it built, but am having trouble building the query below:
Private Sub cmdDisplay1_Click()
Dim strSQL As String
strSQL = "SELECT * FROM tblPending WHERE PartNumber = '&lblPN1.Caption&' INSERT INTO tblFinished"
DoCmd.RunSQL strSQL
End Sub
I am wanting to pull in the value lblPN1.Caption and let the query use it to find the value in tblPending and move it to tblFinished. Thanks for any help.
Private Sub cmdDisplay1_Click()
Dim strSQL As String
strSQL = "SELECT * FROM tblPending WHERE PartNumber = '&lblPN1.Caption&' INSERT INTO tblFinished"
DoCmd.RunSQL strSQL
End Sub
I am wanting to pull in the value lblPN1.Caption and let the query use it to find the value in tblPending and move it to tblFinished. Thanks for any help.