Thanks for this. It doesn't quite work though. I've checked and rechecked the form and field names but it keeps returning this error message.
"Microsoft Office Access can't find the field 'Documents & Work Items subform' referred to in your expression."
Which seems weird - it's a subform not a field. Is there some reason it would be ignoring the .form on the end?...
pjg
Last Activity: Apr 5 '07, 05:45 AM
Joined: Apr 2 '07
Location:
-
VBA for creating new record and copying data
I'm moderately handy with Access but haven't any coding training/experience with VBA - but from other posts I've read I think I need to use it to do what I want.
I have a form called Work Items in which I have a subform called Documents & Work Items subform. There's a button in the Work Items form which opens a form called Documents to a blank record.
What I want is for users to be able to enter details in the Documents...
No activity results to display
Leave a comment: