Originally Posted by
gumbi17
...it is a form with a subform...I am not sure I have a subform control
If you have a Subform on your Form, you do, in fact, have a Subform Control; it's the only way this can be done!
Originally Posted by
gumbi17
...this is what I have currently and I should move the Master to Well master and Child to Memos is that correct?...
No! Assuming that 'Lease Num1' is the name of the Autonumber Field in the Well Table, and also the name of a Number Field, in the Memos Table, the Link Master Fields/Link Child Fields Properties are set as they should be! The Access Gnomes will now use this setup to automatically keep the two Tables synchronized, no code needed!
While Macros in 2007/2010 are more powerful than in previous versions, and now include limited Error Handling, they still offer far less flexibility, in what can be done and how it can be accomplished. The use of them also makes it more difficult to understand what is being done, and, once again, how it is being done, compared to VBA code.
Using VBA, you can go into a Form's code module and view the majority of the Commands used to power the Form.
Using Embedded Macros, in order to view what is being done, as well as how it is being done, requires going, one at a time, into each and every Macro, in order to view what to me, with over a decade of experience developing Access apps, is a series of unrecognizable Commands, methods and qualifiers.
Six years into these 'new and improved' Macros, very, very few of the experienced developers, here, or on any of the other half-dozen Access forums I contribute to, utilize Macros, with the possible exception of Autoexec, a specialized Macro that runs when an Access Database first fires up.
I'm afraid if you want to learn to write truly powerful Access databases, you're going to have to bite the bullet and learn VBA, especially if you want to learn to do so utilizing help from Access forums.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007