Tabbed Form not saving data

[pmathobela]

Hi All,

I having yet troubles with a form that has tabs. I have 3 tabs. I can capture details on each but the problem comes when I try saving. First time its saves. The second time I capture details for the second student it only saves data on the first tab into a table, and when I check other tables for the rest tabs they are empty.

The other thing is on the first student, when I add more info on subform(on 2nd Tab and going right across) it does not update. Is it a problem of relationships between the tables?

Thank again guys!

 

[boblarson]

First off yes it probably is an issue with either the relationships OR what you have as the record source of each subform (I hope it is a subform on each tab, except perhaps the first one).

You can't include the other tables in each of the record sources. So, for instance, if I have my main table (say tblMain) and I have a subform on the second tab which has info in my table tblChild then my record source for the subform on the second tab must NOT have tblMain in it at all. It should ONLY have the tblChild table as the record source (either the table itself or a query based on that table).