The following is the problematic section of code, in a form opened from another. The form which opens it, is a main Client form. On the form which is opened from a click on the Client form, it updates a field ( Disability_Type_IDS ) in the main table used by the first/calling form. How can I avoid this 'conflict' occuring.
Th error message occurs on the line .Edit.:banghead:
Code:
Set db = CurrentDb
Set rst = db.OpenRecordset("SELECT tblClients.Disability_Type_IDS " & _
"FROM tblClients WHERE " & _
"(((tblClients.Client_ID)=" & Forms!frmClients.cl & "));", dbOpenDynaset)
If Not (rst.BOF And rst.EOF) Then
With rst
.Edit
!Disability_Type_IDS = strDisType
.Update
End With
End If