Adding New Record in Subform

[ctgrib]

I have a main form (Form_1) with a tab control that has five pages with a subform on each (Subform_1 - Subform_5). Form_1 has no data. Subform_2 through Subform_5 are linked via the child field "RequestID" (number/long integer; foreign key) to the parent field "RequestID" (autonumber; primary key) on Subform_1. Note: in the Link Master Fields box for Subform_2 through Subform_5, I have "forms!Form_1!Subform_2!RequestID" and so on.

What I need: when I open Form_1, I want Subform_1 (first page of tab control) to display where user adds new record. I have this working. Then, when user clicks on one of the tabs for Subform_2 through Subform_5, I want them to be able to enter information on each of these subforms and have it write to the respective tables with the same "RequestID" that was added on Subform_1. Each subform can have multiple records and I have a button on each one to add a new record.

I currently have the subforms (2-5) requery "on current", and it works for the first record, but when I go to add another record on one of the subforms, I get the message "Can't go to the specified record".

Any help is GREATLY appreciated!

 

[mdmilner]

I may be confused (easily done with me) but,

Check your relationships. Do you have a One-to-One between SF1 & SF2-5 or is it a One-to-Many?

 

[ctgrib]

I have them set up as one-to-many, because for each request ID on subform_1, subform_2 can have multiple entries, and so forth. What should they be set up as?

 

[mdmilner]

I would have said One-to-Many allowing duplicates in Sub_Form2-5 but not allowing duplicates in Sub_Form1.

What code do you use behind your 'add record' button?
Are you generating a unique key in :
forms!Form_1!Subform_1!RequestID

 

[ctgrib]

I have one-to-many allowing dups in 2-5, and am not allowing dups in 1.

The only unique key I have in subform 1 is RequestID, which is an autonumber. Each RequestID on that form can only have one "entry" or set of information. There is not an "Add Record" button on that form.

The code behind the "Add Record" on subforms 2 -5 is:

DoCmd.GoToRecord , , acNewRec

I was thinking I needed to requery somehow, so I added Me.Requery, and that didn't change anything.

Any ideas? Your help is greatly appreciated!

 

[bat17]

What happens if you try to goto a new record manualy? either with the menu or paging down after the last entry?

Peter

 

[mdmilner]

I'm at a loss to help except to suggest that you try to test the problem with a 'fresh' database. Make a new mdb and copy your tables, setup your relationships.

I'd suggest two ways.
First
sub_form1 fields in the main form
sub-form2-5 as subforms

Second
Mainform
Sub_form1 as subform
sub_form2-5 also as separate subforms

I'm not sure why, but I'm wondering if the problem is because all of your forms (sub_form1-5) are all subforms of a single mainform. Just guessing...

Mike

 

[ctgrib]

That actually was the problem. I moved the subform_1 fields to the main form and that corrected it! Thanks again for your help!