Hi
I'm hoping somebody can help.:-)
I have a form where the user must make selections from three combo boxes, 1.Select Customer, 2. select Contact & 3. select Currency the 2nd & 3rd are bound to table QuoteHead, after the 2nd combo box is updated a quote no is generated and bound to QuoteHead using a before insert event.
Within the form I have a subform (QuoteLine), what I really want to do is, when the user makes an entry into QuoteLine I want to lock the 3 combo boxes on QuoteHead.
I have used this code on an after insert
If IsNull(Me.Combo41) Then
Combo41.Locked = False
Else
Combo41.Locked = True
End If
The same code for combo43 and the same for Currency. (If it's relevant the Currency field is set to a combo box at table level)
The code works for the first 2 combo boxes but then fails on the Currency field.
I am way off the mark with this?
Any ideas greatly appreciated.
Thanks
Julie.