How to Insert an unbound Form into table

[fekrinejat]

Hello

I need to use VBA for inserting, form objects values into tables
Would you tell me how to write vba code ?

exp: Tbl1(S_ID(PK), S_Name, S_Tel) and Tbl2(T_ID(PK), S_ID(FK), Entry_Date)



Thanks

[pbaldy]

Simplest would be to create an append query that got the values from the form, and execute it from code. Alternatively, the AddNew method of a recordset. Using unbound forms is much more involved that using bound forms.

[RuralGuy]

To follow up a bit on Paul's comments: why do you feel you should use an unbound form?

[fekrinejat]

How can i run a query by vba ? would you give a real samle ?
actually when i use bound objects, user can see whole the information through its navigaor,
although i know it can be done easily but i don't want to show it in Form ..

[pbaldy]

I'd use bound forms, but you can run the query via

DoCmd.OpenQuery