Form and Subform with same record source (1 Viewer)

[jerem]

Hi
I created a form and a subform with the same record source. The reason for that is that I have a tab in a tab, and the only way to get that to work is to create a subform. So my Form has an ID field and mu Subform also has an ID field, which essentially is the same field. Now if I try to save the changes that I make in this form and subform, I get the duplicate value error.
Any idea how I could address this?
Thanks

Cross:
http://www.accessforums.net/forms/form-subform-same-record-source-47565.html#post249143
http://www.utteraccess.com/forum/Form-Subform-Source-Ta-t2022829.html#entry2495014

 

[jerem]

Ok... To get it to work, I changed the Master-Child link: Now, Link Child Field is the field ID and Link Master Field is the control txtID. No duplicate value issue anymore, however now it creates an extra empty record when using the form to add data. Should I get rid of it manually or is there something I am not doing right?

 

[gemma-the-husky]

I can't think why you would want a subform based on the same record

I would add a tab control, and put the extra details you want on there.

 

[jerem]

Because, as explained it is a tab in another tab. So try to do that without using a subform. If you find a way please do let me know.