Hello Computer People,
I'm an "advanced ameatur" MS Access user who is having the same issue as was described in this thread:
http://forums.techguy.org/business-a...rm-opened.html
As Melonhead and I found, a split form inserted into another form essentailly becomes a form within a form (making the datatable dissappear).
(If I'm understanding correctly) melonhead found a way to make a datasheet control the records in a regular form (acting like a split form).
I am able to but the two subforms together, make them reference the same table, but I have no clue how to make them "talk". I have no problem with reading on my own to find out how, I just have no idea what I should be searching under.
My sales reps are used to pulling up records on a split form due to the ease of sorting (and thats what I gave them to work with for the past year). However if somone has another suggestion, I am open to hearing it.
I am willing to trade technical knowledge of ceramic tile in exchange for some help. I'll also be really really nice to you.
Thanks
TileGuy
I'm an "advanced ameatur" MS Access user who is having the same issue as was described in this thread:
http://forums.techguy.org/business-a...rm-opened.html
As Melonhead and I found, a split form inserted into another form essentailly becomes a form within a form (making the datatable dissappear).
(If I'm understanding correctly) melonhead found a way to make a datasheet control the records in a regular form (acting like a split form).
I am able to but the two subforms together, make them reference the same table, but I have no clue how to make them "talk". I have no problem with reading on my own to find out how, I just have no idea what I should be searching under.
My sales reps are used to pulling up records on a split form due to the ease of sorting (and thats what I gave them to work with for the past year). However if somone has another suggestion, I am open to hearing it.
I am willing to trade technical knowledge of ceramic tile in exchange for some help. I'll also be really really nice to you.
Thanks
TileGuy
you should post a sample db with sample data.
YanıtlaSilBut lets be clear on what you are trying to do... make a subform where it is a "one to many" or a "split form" (Access 2007 only) which relates to a single table.
There does appear to be a problem with Access 2007 Split Forms when used in the way that you and Melonhead want to do.
YanıtlaSilI suggested to melonhead that he use normal subform to achieve the same format.
What you can't do with ordinary subform is have the First subform in Datasheet or Continuous Forms mode. If you want a single rcord on the first subform and a Continuous form on the second one that is Ok.
Unfortunately I can't open Access 2007 databases per Ziggy's suggestion, but a screenshot of your Split Form (Not as a Subform) woudl help.
Hello,
YanıtlaSilI'm glad that screen shots work for you as I was having trouble making the DB small enough to upload.
2 photos, SplitForm.jpg is of the split form that I designed and was hoping to insert into a tab of another form
2SubForms.jpg is, well, 2 sub forms that I was hoping to make the datasheet on the bottom determine what record is selected on the top screen.
Is there any hope for me?
Thanks
TileGuy
Attached Thumbnails
ms-access-split-form-opened-2subforms.jpg ms-access-split-form-opened-splitform.jpg
I get what you want, but seems like the Split form may have a bug when trying to add it to a tab control or make it a sub. I gather that for each of those people names on the tabs the records below are to be filtered for them.
YanıtlaSilI've searched this topic and it's funny because just talking about it (because it is new) every one assumes the poster ( in other posts) is talking about a subform not realizing there is new functionality, to be honest I have not really experimented with the new functionality of the split form.
I'm sure there is something we can come up with but it's hard to work from screen prints, if you can dummy up a smaller example it might help
ileGuy, I can't open your 2007 database.
YanıtlaSilThe Master/Child link is created between the Mainform and Subform and can be totally independent of the Table relationships, or as is most usual, it can use them.
However if you establish the the Master Child link it only works in one Direction, i.e. from the Master to the Child. So in effect once you select a Record in the Master form the only Record(s) showing in the Subform are those that meet the Link, which in your case (based on one table) it will be only one record displayed. So it would not be possible to select a record in the Subform and move to it in the mainform.
The only way to do that is to have no master/child link and use VBA to move to the required record either in the Subform or in the Mainform.
Would you like to do that?