construct a form using design view to insert data to multiple tables

[saleemMSMS]

without creating a form through the wizard, what is the way to create a form using the design view and coding manually ? is there a way of doing this ? pls explain coz i'm new to access VBA. but i'm fluent in C# so is there a way ??

 

[HiTechCoach]

Without more specific on the tables and how the are related, iI can only guess.

Normally in Access you can use a form and sub forms to enter data into a parent table and related tables (sub forms). NO VBA required!

 

[grizzlyjdw2]

i had a situation where i had 2 seperate tables and needed to write the same data to both tables in some cases. the only way i could find to do it was link one table with the form directily (this was the table i always needed to write to) then write to the other table using vba (given certain criteria)

i suppose you could do both tables with vba if you didn't have constraints put on your data.