Hi pplz,
I have a button called "add" which adds the parent table/forms ID's batch number (primary key) to the data in a table of the subform
So
Master Invoice (Parent)
- InvID
Scripts_No_Inv (sub1)
Private Sub Command9_Click()
Me.InvBatch = Me.Parent!InvID
Me.Requery
Me.Parent.SubInvoiced.Requery
End Sub
SubInvoiced (sub2)
Private Sub Remove_Click()
Me.InvBatch.Delete
Me.Requery
Me.Parent.Scripts_No_Inv.Requery
End Sub
So "add" button adds the parent InvID as the InvBatch. This works well and the forms work and the querys re-query. No probs here.
The "remove" button doesnt work at all All im trying to do is delete the field value (invbatch) that i have just put in.
.delete is obviously wrong, but ive tried Me.InvBatch = Null which also doesnt work beacuse it thinks im trying to relate the table to a InvID that is null?
I just need the field "InvBatch" to be empty again
Sorry ive tried googling HEAPS but still no answer!!!
Ty for any advice!