Search results

After pressing debug, the following line is highlighted in yellow: Forms![FrmPurchaseOrders].[JobID] = Forms![FrmJobs].[JobID] When I hover over JobID of both references above I see the following: acNewRec=5 I checked for missing references but couldn't find anything?

Yes the control on both forms is JobID. I'm not sure about missing references RE: MsgBox Forms![FrmPurchaseOrders].[JobID] I copied the original code from another database and changed the control name references so there may be something missing?

I created a new DB and imported all the forms, queries etc. The same error occurs on the new database. I tried shutting the PC down and re-starting incase something was wrong with MS Access. I have also tried renaming the individual forms as this has sometimes cured errors in the past. None of...

Hi RuralGuy - Yes it gives the same run-time error 438 with: Forms![FrmPurchaseOrders].[JobID] = Me.JobID David

I have created a command button on a form called FrmJobs. It opens a form called FrmPurchaseOrders, adds a new record and gives the JobID field in FrmPurchaseOrders the same entry as the JobID field from the form FrmJobs: The following Event Procedure works on my previous database but when I...