inserting records from a form "how-to" update foriegn keys

[kellyputty]

I think I have to write some code to get my form to automatically enter the correct foriegn keys in my tables. I am new/rusty on VBA.

Is there a built in way to do this? If not, does anyone know of an Access VBA online (free) tutorial?

 

[PHV]

Provided the relationships are properly set the subform wizard should do the job for you.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886