Originally Posted by
shabbaranks
...I have about 15 fields to which I want to add from a main form into a sub form...
...Hope this makes sense?
Sorry, but as presented, it really makes no sense whatsoever! One of the main points in using a Main Form/Subform configuration is to avoid storing one Field in multiple Table!
Doing so would violate one of the Cardinal Rules of Relational Databases, the Rule of Normalization! Storing a single bit of data in multiple Tables is only acceptable if the Field is being used as a Primary Key/Foreign Key to link two or more separate Tables/Forms.
Perhaps we can help you, if you give us a plain-language explanation, of exactly what you're trying to do, here.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007