Programming Access - is there a quicker\better way?

[shabbaranks]

Hi all,



Im just curious as to the best method of referencing Access objects declaring strings and writing code. I have about 15 fields to which I want to add from a main form into a sub form and Im using VBA. Do I have to declare them all as strings\double etc and then reference the field to the string and then write the code to add the form fields to the subform or am I going about it the long way.

So an example would be:

Dim strName as String, mysql as string

strName = me.formname.fieldname
mysql = ".....Mysqlcode..."

Hope this makes sense? Thanks

[orange]

If you have fields in a mainform that should be in a subform, it sounds like a table structure issue.
Normally you mainform/subform are related in a 1:m set up.

eg 1 Person can have many Hobbies

So in the example you have a Peoples table and possibly a Hobbies table and a junction table PersonHasHobbies

and Person (main Form) and PersonHasHobbies (subform)
and the forms are linked on PersonId

You may have a different set up, if so , please describe in detail with some example data.

[Missinglinq]

...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)>