Re: Macro to enter data into subform
There are different ways of interpreting the problem. The first thing is the subform could either be in datasheet or form view. I suspect you mean it's in form view, however it would be beneficial to know for sure.
I would suggest you create a demonstration database, just the basic components extracted from your existing database to demonstrate what you have and if you can, indicate the results you want. If that's not possible, then some screenshots might provide enough information.
I personally wouldn't enter data directly into a form with code, I would enter it into the table underlying the form using an SQL Statement.
| Uncle Gizmo |
| Get $20 worth of "Nifty Code" |
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| Ooo |
( ) ) /
\ ( (_/