tabs within subforms?

[chaan758]

I am creating a database, in which we have patients and linked to that created subforms, which are all linked as these patients.

The main form has tabs, and within those tabs are the subforms. There are many subforms at least 5 and at the moment I have them organised on the one page which is annoying for data entry as you have to scroll. Is there anyway of having tabs or some kind of control (macro) to click open a particular form for data entry? And maintain the parent-child relationships?

I hope this makes sense!


Thanks in advance

 

[boblarson]

Yes, you can put each subform on a different tab within the main form. Not a problem and especially easy because there is no changes necessary in handling this because a tab control is like it doesn't exist (you don't reference it in code, or for controls on it, etc).

 

[chaan758]

Hi Bob,

Thanks for your reply.

This is actually a tricky one, I was wondering if in the actual subform itself, if I could have additional tabs inside that whilst maintaining parent-child relationship.

For example, tabs with in the subform. (the subform is already in tabs from main form).

Hopefully I have better explained it above, I have re-worded it here to explain my dilemma.

Each subject has several physical assessments with in a day, and one subject has many assessments within a day. The main form has the days separated out in tabs and the subforms can be found within those tabs. Except there are many subforms, so is there a way i could have those subforms within additonal tabs, or some way so as I can have a button to click and open a particular form?

 

[boblarson]

You would need to put additional subforms onto the additional tabs and relate them to the 1st level subform.

 

[chaan758]

hmm I don't think I see the big picture, but I cannot add anymore tabs within the main form, as I have too many now.

In addtion, the 5 subforms within the particular tab, I am unable to move and are required to be there as they are related to that particular tab and I cannot separte them out. Do you have any other suggestions?

Cheers.

 

[boblarson]

hmm I don't think I see the big picture, but I cannot add anymore tabs within the main form, as I have too many now.

In addtion, the 5 subforms within the particular tab, I am unable to move and are required to be there as they are related to that particular tab and I cannot separte them out. Do you have any other suggestions?

Cheers.

What I was getting at was that you can put a tab on a subform and then you put the other subforms onto that subform.

This is a screenshot of a bunch of tabs on subforms on subforms that I had. The Grantees is actually a subform on the main form tab control and then the Clinic sites are a subform on the Grantees form and the Collaboratives is a subform on the tab control which is on the Clinic Sites subform.

 

[chaan758]

Thanks Bob. That is exactly what I want. So can I ask you how exactly the steps involved in doing that? Im still somewhat a basic-intermediate access user (and Im working on access 2000, maybe I cannot not do it in this version?). I didnt realise how complicated things were!

I am somewhat confused actually, as the more I read, about the parent-child relationships and that apparently this will not be kept if I have additional tabs within the subform. Argh.

 

[boblarson]

Well, it will take quite a bit to explain, so what I'm going to do is to post the front end of my database here (not the backend as I don't have time to clean the data out). But if you go into the form in design view (hdcc_main) then you can see how the subforms are set up. Perhaps that will help.

 

[chaan758]

Thanks so much, I really appreciate all your help. I will have a look at it and try to decipher it