Cannot edit sub form

[spidge32]

Hi I have a small database which has a master form for Jobs and a sub form for activities for each job. To open the sub form a click is required on the Job No and the sub form opens a lists the current activities for that Job.
I want the user to edit the sub form activities as to the dates, contractors etc. The fields are editable but I cannot edit these fields.


I have attached the file.
Thanking you in advance
Bill

[davegri]

Tasman Group Retail Building Services-davegri-v01.zip

Made a couple of changes. You don't need a table to hold the job code. A Tempvar will do just fine. None of the red needed.

Private Sub jobcode_Click()
'    Dim wSQL As String
'    Dim sSQL As String
'
'    'Delete OldRecord
'
'    DoCmd.SetWarnings False
'    dSql = "DELETE From JobLineNo"
'    DoCmd.RunSQL dSql
'
'    DoCmd.SetWarnings True
'
'
'    Debug.Print sSQL
'  ' CurrentDb.Execute sSQL, dbFailOnError
'
'   CurrentDb.Execute "INSERT INTO JobLineNo (JobLineNo) VALUES ('" & jobcode & "')"
   
   TempVars!tvjobline = Me.jobcode.Value
   DoCmd.Close acForm, "frmJobList", acSaveYes
   DoCmd.OpenForm "frmJobLineItems", acNormal, "", "", , acNormal
  
End Sub

Then the query needs to include the tempvar



frmJobLineItems should NOT be DataEntry = Yes



I think that's all I changed. If not, any and all changes in the uploaded DB.

[spidge32]

Hi,

Thanks for the information and changes. I have never used tempvars, I will use it in the future.

Cheers

Bill

[davegri]

Found more problems. qryJobLines, which is the recordsource for frmJobLineItems is editable, but the form is not, because of Locked properties of some of the form's textbox controls.
In addition, with these controls unlocked, the user has to type in the jobcode (it's the primary key but not an autonumber) and also the Sequence.
To alleviate some of this requirement, the form setup should be form/subform with table Job Master as the main form and Job Line Items as the subform.
Ideally JobSeq should be an autonumber, but at this point that would require a pretty large commitment to map and replace the existing FKs in the child table.

[spidge32]

Hi,

I will make the changes as you have suggested, The JobSeq comes from the import from the sql database so I left it as imported.

Thank you for your help

Cheers Bill