Mutiple subdatasheets

MPater

Registered User.
Local time
Today, 09:41
Joined
Aug 14, 2014
Messages
19
I am setting up a database that is constructed of a main form related to several other forms via the same primary key in the main form. However, when I click on the +-symbol in the main form for the first time, I am asked which related form to select, and thereafter the connection is limited to that form only. I cannot "relate" to any of the others, which defeats my objective. HELP!!!
 
the +-symbol
In design view or where do you have this +-symbol, (do you have you a navigation control in the form)?
Post a printscreen of what you've, (zip it because you've not post 10 post yet).
Or post you database with some sample data + info how to reproduce your problem.
 
I think the OP is talking about nested subforms.
 
I can't have made myself clear - nothing new there! I should have referred to tables rather than forms. After I have related the parent table to several other tables , using the primary key in the parent table for the joins in all cases, the "+"-symbol appears on the extreme right-hand side of all the records in the datasheet view of the parent table. Clicking on +-symbol opens the child table that has been selected the first time the procedure is carried out, and only that child table can be connected henceforth. What I wish is for all the child tables to be available.
 
Sorry - I should have written "left-hand side", not right-hand side. More haste, less speed.
 
If you open the main table in design view, then you can remove the sub table, (the main table's property "Subdatasheet Name"), and insert a new one either in design view or when you open the main table again.
But why do you want that, it isn't any good to work direct in tables, use form instead.
attachment.php
 

Attachments

  • SubTables.jpg
    SubTables.jpg
    73.1 KB · Views: 372
Thanks, but no cigar. The property sheet for the main table only lists Field size, New values, Format, Caption, Indexed, Smart tags and Text align. I am using Access 2010, in case that is relevant.

Incidentally, as a side issue, I fail to understand the preference for forms. I am perfectly happy with tables, and find them much easier to work with. But it takes all sorts.....
 
Thanks, but no cigar. The property sheet for the main table only lists Field size, New values, Format, Caption, Indexed, Smart tags and Text align. I am using Access 2010, in case that is relevant.
You are not looking at the table property, but on a field property - look at the attached picture.
 
You've lost me now. The only table property sheet that I can find only has a "General" tab. Where do I find the one you illustrate?
 
Open the table in design view, right click, second chose from the bottom.
Or click on icon for the property sheet.
attachment.php
 

Attachments

  • Prope.jpg
    Prope.jpg
    17.4 KB · Views: 339
I think there must be a communication issue. Following your instructions, all I get is the tables "General" tab, which contains nothing of relevance.
 
I think there must be a communication issue.
I do agree! :D :D
Attached is a picture with some step by step description, hopeful you'll get it now! :)
I suppose you use MS-Access 2010, but I'm not sure, maybe that is the issue.
 

Attachments

  • Pow.jpg
    Pow.jpg
    87.1 KB · Views: 113
Following those exact steps, all I get is the "General" tab, as before. I'd show it to you if I could work out to paste a copy into this thread.
 
I would if I knew how to post a screen shot into a reply to this thread, but I don't. I am having the same issue with JHB
 
Here is the screen shot for JHB
 

Attachments

  • Screenshot.jpg
    Screenshot.jpg
    95 KB · Views: 140
Click somewhere on the Rh side of the screen, not the navigation pane. And then you should be able to see the table properties.

As to your field names - try to get a consistent naming convention. Lack of consistency will otherwise chew up your derriere at some stage.
 
spikepl: Rh side of which screen? See JMB's screenshot. And I see no inconsistency in my namimg of fileds.
 
AccessBlaster: ContactID is the join for all the subdatasheets. Access does indeed ask for a choice when opening a subdatasheet for the first time, but thereafter that is the only choice available. That is precisely my problem. I wish to be able to make the choice each time I carry out some data entry.
 
Outside of the norm, maybe, but therefore impossible? How can I achieve what I want?
 

Users who are viewing this thread

Back
Top Bottom