Adding new record with two Forms

E

Eric

My problem is this. I have two tables 1. Project Info (name, address,
type, etc.) and a second table for Plans, pictures, financials.

The issue is - When i Add a new project. and go to the second form to a
info I loss data is second table/second screen.

If I add info to first screen. goto another record and then back to the NEW
record. I can add second screen info with no problem.

What is the best way to save data in form one before going to form two?

I was thinking of code to move next and then move previous but can't
remember how to do that in Access. Help.
 
M

MacDermott

Two ways that you might consider:
Me.Dirty = False
DoCmd.RunCommand acCmdSaveRecord
 
Top