Tab Control & subform (A2K)

Topic

New Reply

I can’t explain why you can’t go to another tab page, but I don’t understand why the record source of the main form includes tblSub. I’d think the main form should be based on tblMain only and the subform on tblSub.

If you wish, you can post a stripped down copy of your database. That will enable Loungers to investigate the problem directly. See post 401925 for instructions.

Reply | Quote

Replies

My form has a Tab control with 5 pages. The Tab control is populated with SQL “Select * from tblMain Inner Join tblSub on [tblMain].[ID] =[tblSub].[ID]”. On the last page is a subform with the Link child filed ID and Link master field tblMain.ID. The record source for the subform is “Select * from tblSub”

I can navigate to all the pages with data from tblMain. However when I activated the tab page with the embedded subform and tried to enter some data, I could not go to another tab page and was stuck at the tab page with the subform until I exit the program.

With this sketchy description, can anyone tell me what is (are) the possible reasons?

Reply | Quote

tblMain and tblSub are two tables related by ID (one-to-many relationship). The tab control essentially displays data from tblMain but with the last page displays data, if any, from tblSub. The tblMain is actually the student info and tblSub indiscipline records, one indiscipline kes one record. I want to add records of indiscipline of a particular students if there is one. Am I not using the query correctly?

Reply | Quote

Since the last tab page has a subform based on tblSub, you don’t need tblSub in the control source of the main form – the main form should be based on tblMain only.

Reply | Quote