Fairly Simple 1

[jimb0ne]

I have a problem in which from a main form, I got to subforms to enter information. The problem is the subforms tables are linked via relationships to the table from the main form, when I am entering a new record, the mainform information has not yet saved to the table when I try to enter data into the subforms tables, hence I get an error saying that there is no related key in the main table. What code do I run to write the information from the main form to its related table, before I open the subform for the user to enter information on the other tables?

thanks in advance,
jimb0ne

 

[PHV]

Have you tried this ?
DoCmd.RunCommand acCmdSaveRecord

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

 

[jimb0ne]

heh, no, I couldn't remember what to use, and I'm running access in spanish so I'm totally lost when it comes to the documentation. Thanks again for the help, exactly what I need.