Multiple Forms for 1 Table

J

Jfhayes

I have a database I was left with that has 2 forms for 1 table. One form is the master form, another is a subform. I know in the long run I will have to split the table and create new forms. In the short run I need to know when you add new data on the master form, then immediately have to add data to the corresponding subform, how can you prevent the duplicate id error message from Appearing? Is there anyway when focused is on the subform, to immediately go to edit mode instead of data entry mode?
 

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

Main Form with Subforms 5
Help with form load 5
Embed the same Excel multiple times 0
Data entry for a table from a form 2
My input form isn't empty? 5
Setting subform to add mode while main form is in edit mode 9
Why is my "continuous form" subform not working right? 10
Need a button to add records to subform table without link 1

Top