Thanks for that, I've been looking at this for ages, and couldn't see what was wrong.
Works fine now.
Regards
Pete
pzh20
Last Activity: Aug 27 '08, 03:53 PM
Joined: Aug 27 '08
Location: London England
-
Populating fields when adding new record via datasheet subform
I have an unbound form/subform where I populate a combo box on the main form, and using the onchange event, display fields from a table in a datasheet subform.
I want to add a new record via the subform, allowing the user to type certain fields but complete other fields via code in the beforeinsert event as follows
Private Sub Form_BeforeInse rt(Cancel As Integer)
Me.Kitchen = Me.Parent.Kitch en(2)
Me.lookupRoute...
No activity results to display
Leave a comment: