New record error on Navigation Form

[AlvaroCity]

Hello everyone.

I have a navigation form in which there are 2 tabs. The main form has only the ID field whereas on the tabs the fields are linked to the ID from the main form.

The problem is when I want to introduce a new record. The new records I want to introduce are on the first tab but when I start typing, a error message pops up. This is because the ID field is on the main form instead of the tab.

The code used to open the navigation form is:

DoCmd.OpenForm "frmClientes", acNormal, , , acFormAdd

To make it clearer I recorded a video on youtube. I hope this will be helpful. If there is anything

https://www.youtube.com/watch?v=HBqOf7h6dC4

Thank you

 

[BJF]

you need to get the clientID out of the header and put it on the form.
you can put it anywhere on the first tab, then make visible set to no if you dont need to see it.

 

[AlvaroCity]

Hello BJF

I think the ClientID has to be in the main form as it is needed as to set the link master and child master fields from both tabs.

Am I wrong?

Thank you for your answer

 

[AlvaroCity]

Please I need help. I couldn't still find a solution...

 

[AlvaroCity]

No solutions yet???

 

[static]

All of your screen appear blank.

A child record will need a parent record to inherit values from.

If your sub form is linked to a blank record it will no worky.

 

[AlvaroCity]

Hi Static

I think the problem is that the display of the records.

What i have been looking for is a way to display on the first tab all the information and on the second tab a subform linked to the first tab.

Cos I could not do this. What I did was to put just the ID on the "main" form and the rest of the records on the first tab, and the second tab like a subform of this.

thanks