Subforms in the Tab control

[74maiden]

Hi,

I have 4 pages in a tab control where each is a subform but the main form and tab control with the subforms dont seem to be linked and therefore dont see any data in the pages when i navigate thru the main form.

I have the child/master setup for each, is there something i´m missing because of the tab control.

Thanks...

 

[annsolomon]

I use tab controls but I don't have a clear understanding of what you're doing. Can you describe your setup a little bit. What's on your main form and what kind of info do you have on your subforms? Are you saying that if you click on the second subform form (page)then navigate through the main form, the records on the subform don't change?

Ann

 

[74maiden]

Hi Ann,

If I click on any of the pages on the Tab then none of the data appears when I navigate thru the main form.

Thanks for your help !

 

[annsolomon]

Sorry, but since you didn't give me the info I asked for, I'm no closer to helping than I was before. How about the info?

Ann

 

[74maiden]

Sorry,


The database is based on different queries for an advertising company.

I have a main form with a Recordsource from a table called ´Query´.

I have a Tab Control with 4 pages/tabs on the main form where Page1 has a subform and a recordsource called ´Product´, Page2 has a subform and a recordsource from a table called ´Customer´, Page3 has a subform and a recordsource from a table called ´Sales´, Page4 has a subform and a recordsource from a table called ´Complaint´,

These tables are all linked to the Query table in the relationship view. Also, they are linked from the main form to the subforms on each tab by populating the master/child field.

This form is only for viewing the data by navigating thru the main form but data from any of the subforms on the pages dont appear.

PS The data entry is done on totally different forms and by viewing the data in all the tables it all looks fine and linked.

Hope this helps you more.

74maiden

 

[annsolomon]

Try putting some code behind the OnCurrent event for each of your subforms that sets the subform unique field (e.g., Product) equal to the related field on the main form.

Let me know if that helps or not.

Ann

 

[annsolomon]

I just put together a MainForm/TabControlWithSubforms using the wizard and navigation via the MainForm works perfectly (even without coding the OnCurrent event). There must be something else going on.

I'll keep the thinking cap on but maybe someone else will have some ideas for you.

Ann

 

[annsolomon]

I guess I should have asked you to clarify exactly what you mean by "data from any of the subforms on the pages dont appear". Is it possible that you have the DataEntry property on the subforms set to True so all you're seeing in the subform is an empty record?

Ann

 

[74maiden]

Ann,

Sorry about the late reply, I´m in GMT. I already tried to put code into the OnCurrent event, it didn´t help and the data entry property is set to false in the subforms.

I´ll think about it over Xmas, thanks for your help.

74maiden

 

[annsolomon]

74Maiden, have you had any new thoughts? My home computer has been down for days. (Got a new one today and loving it.)

Are you in a position to send me a copy of your database. Obviously, I don't want you to get in a compromising position at work but it's always easier to troubleshoot when you can "see" what you're "looking" at.

Let me know.

Ann

 

[74maiden]

Ann, thanks for your ongoing concern, fortunately I found the problem.

The person who maintained the database prior to me created a field that was used for the link between the mainform and the subforms.

I couldnt find the link on the form because it was minimized to no width and set to visible = false, I did a edit-select all and found it (although it was difficult to see it). Anyway changed the linking field and it works fine now.

Thanks for all your help, 74maiden
hope you had a good xmas !

 

[annsolomon]

Good for you.

Ann