Adding new record with two Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Two ways that you might consider:
Me.Dirty = False
DoCmd.RunCommand acCmdSaveRecord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Forms and New Record 1
Need combo box to refresh when moving to new record 2017 1
Return to Main, Same Customer, New Record 10
Problems adding new record from form / subform 6
Access Automatically Send a notification email once a record is added 0
How do you render a record in a continuous Data Entry Form? 10
Problem adding a new record to a subform 1
Pop-up form that creates record that links 1:1 to main form 0

Back
Top