Forms and Subforms issues.

Hello everyone!

I need some major assistance on a personal project.  I've been stuck
on the whole subforms issue (not that I don't know how they work).  In
any event, I've been creating a personal DVD collectoin database, and
have done fairly decent until now.

I have a main form that I want to use and display the same information
in two different ways. On the left side of the form, I want to use a
query (subform) to display a list of all the movies that I do own.  I
on the right side of the form, I want to have another subform listed
to detail all the information of the selected movie on the left.
Furthermore, I want the information on the right to change according
to the selected movie on the left subform.

Any suggestions?

Please let me know if any more information is needed.

Thanks!

Charles

0
Charles
7/2/2007 2:04:37 PM
access.forms 6864 articles. 2 followers. Follow

7 Replies
817 Views

Similar Articles

[PageSpeed] 13

Charles.Pierrot.II@gmail.com wrote in
news:1183385077.914254.147240@g4g2000hsf.googlegroups.com: 

> Hello everyone!
> 
> I need some major assistance on a personal project.  I've been
> stuck on the whole subforms issue (not that I don't know how
> they work).  In any event, I've been creating a personal DVD
> collectoin database, and have done fairly decent until now.
> 
> I have a main form that I want to use and display the same
> information in two different ways. On the left side of the
> form, I want to use a query (subform) to display a list of all
> the movies that I do own.  I on the right side of the form, I
> want to have another subform listed to detail all the
> information of the selected movie on the left. Furthermore, I
> want the information on the right to change according to the
> selected movie on the left subform. 
> 
> Any suggestions?
> 
> Please let me know if any more information is needed.
> 
> Thanks!
> 
> Charles
> 
You should use a listbox, not a subform, on the left side of 
your form. Then you set up the subform on the right side of the 
form..The link parent field for the subform is the name of the 
listbox. 



-- 
Bob Quintal

PA is y I've altered my email address.

-- 
Posted via a free Usenet account from http://www.teranews.com

0
Bob
7/2/2007 4:13:15 PM
On Mon, 02 Jul 2007 07:04:37 -0700, Charles.Pierrot.II@gmail.com wrote:

>Hello everyone!
>
>I need some major assistance on a personal project.  I've been stuck
>on the whole subforms issue (not that I don't know how they work).  In
>any event, I've been creating a personal DVD collectoin database, and
>have done fairly decent until now.
>
>I have a main form that I want to use and display the same information
>in two different ways. On the left side of the form, I want to use a
>query (subform) to display a list of all the movies that I do own.  I
>on the right side of the form, I want to have another subform listed
>to detail all the information of the selected movie on the left.
>Furthermore, I want the information on the right to change according
>to the selected movie on the left subform.

You can do this with the help of a "relay" textbox on the main form.

Set its Control Source to

=LeftSubformControl.Form!Controlname

using the name of your left subform (the Subform Control, not the name of the
form within that control), and use the name of a control on that form which
contains the unique DVD ID in place of Controlname. 

Then set the Master Link Field property of the second subform to the name of
the textbox - you'll need to just type it in, the wizard won't offer it as a
choice.

You may need to Requery the textbox and/or the second form in the Current
event of the first subform.

             John W. Vinson [MVP]
0
John
7/2/2007 5:18:58 PM
On Jul 2, 12:18 pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> On Mon, 02 Jul 2007 07:04:37 -0700, Charles.Pierrot...@gmail.com wrote:
> >Hello everyone!
>
> >I need some major assistance on a personal project.  I've been stuck
> >on the whole subforms issue (not that I don't know how they work).  In
> >any event, I've been creating a personal DVD collectoin database, and
> >have done fairly decent until now.
>
> >I have a main form that I want to use and display the same information
> >in two different ways. On the left side of the form, I want to use a
> >query (subform) to display a list of all the movies that I do own.  I
> >on the right side of the form, I want to have another subform listed
> >to detail all the information of the selected movie on the left.
> >Furthermore, I want the information on the right to change according
> >to the selected movie on the left subform.
>
> You can do this with the help of a "relay" textbox on the main form.
>
> Set its Control Source to
>
> =LeftSubformControl.Form!Controlname
>
> using the name of your left subform (the Subform Control, not the name of the
> form within that control), and use the name of a control on that form which
> contains the unique DVD ID in place of Controlname.



Ok, I'm on the right path as I had this part on my form too.  It is
working up to that point without a problem, as I can scroll through
the list and populate the movie name to the other text box outside the
subform.


> Then set the Master Link Field property of the second subform to the name of
> the textbox - you'll need to just type it in, the wizard won't offer it as a
> choice.

Here's where I get stuck.  I know of this property that you're
referring to, but I don't have that option available.  I"m not sure if
I setup my second subform correctly, as this already created form that
I have.  Did I not set my form correctly? What can I change on my form
to get it to show these fields?

> You may need to Requery the textbox and/or the second form in the Current
> event of the first subform.

This part makes sense, once I can get the previous part working.
>              John W. Vinson [MVP]


0
Chuck
7/2/2007 7:54:37 PM
On Jul 2, 2:54 pm, Chuck <Charles.Pierrot...@gmail.com> wrote:
> On Jul 2, 12:18 pm, John W. Vinson
>
>
>
>
>
> <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> > On Mon, 02 Jul 2007 07:04:37 -0700, Charles.Pierrot...@gmail.com wrote:
> > >Hello everyone!
>
> > >I need some major assistance on a personal project.  I've been stuck
> > >on the whole subforms issue (not that I don't know how they work).  In
> > >any event, I've been creating a personal DVD collectoin database, and
> > >have done fairly decent until now.
>
> > >I have a main form that I want to use and display the same information
> > >in two different ways. On the left side of the form, I want to use a
> > >query (subform) to display a list of all the movies that I do own.  I
> > >on the right side of the form, I want to have another subform listed
> > >to detail all the information of the selected movie on the left.
> > >Furthermore, I want the information on the right to change according
> > >to the selected movie on the left subform.
>
> > You can do this with the help of a "relay" textbox on the main form.
>
> > Set its Control Source to
>
> > =LeftSubformControl.Form!Controlname
>
> > using the name of your left subform (the Subform Control, not the name of the
> > form within that control), and use the name of a control on that form which
> > contains the unique DVD ID in place of Controlname.
>
> Ok, I'm on the right path as I had this part on my form too.  It is
> working up to that point without a problem, as I can scroll through
> the list and populate the movie name to the other text box outside the
> subform.
>
> > Then set the Master Link Field property of the second subform to the name of
> > the textbox - you'll need to just type it in, the wizard won't offer it as a
> > choice.
>
> Here's where I get stuck.  I know of this property that you're
> referring to, but I don't have that option available.  I"m not sure if
> I setup my second subform correctly, as this already created form that
> I have.  Did I not set my form correctly? What can I change on my form
> to get it to show these fields?
>
> > You may need to Requery the textbox and/or the second form in the Current
> > event of the first subform.
>
> This part makes sense, once I can get the previous part working.
>
>
>
> >              John W. Vinson [MVP]- Hide quoted text -
>
> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -


Update: I did find the Master Link without a problem.  However, the
2nd form on the right is actually a form that I created to gather all
the information from the same table that the query in the subform on
the left pulls from (the form on the right isn't a query at all).  I
still want to poplulate the rest of of the information based on the
supposed textbox that's mentioned earlier (which carries over the
actual title now).

0
Chuck
7/2/2007 9:00:55 PM
On Mon, 02 Jul 2007 21:00:55 -0000, Chuck <Charles.Pierrot.II@gmail.com>
wrote:

>Update: I did find the Master Link without a problem.  However, the
>2nd form on the right is actually a form that I created to gather all
>the information from the same table that the query in the subform on
>the left pulls from (the form on the right isn't a query at all).  I
>still want to poplulate the rest of of the information based on the
>supposed textbox that's mentioned earlier (which carries over the
>actual title now).

I have no idea what you're telling me here, Chuck.

Remember: you can see your form. I cannot.

What are the Recordsources of the two forms? Please post the SQL or the
fieldnames from the table.

What is the Control Source and name of the textbox?

What is the Master Link Field?

What result are you getting, or not getting that you want?

             John W. Vinson [MVP]
0
John
7/3/2007 12:32:48 AM
On Jul 2, 7:32 pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:

> I have no idea what you're telling me here, Chuck.

> Remember: you can see your form. I cannot.

> What are the Recordsources of the two forms? Please post the SQL or the
> fieldnames from the table.

For the Datasheet Form (the one that was going to list my movies), the
Record sources was "Movie Collection Query."   The query pulled from
the table using the following SQL command:

SELECT [Movie Collection].OwnedDVDID, [Movie Collection].OwnedDVDTitle
FROM [Movie Collection]
WHERE ((([Movie Collection].VerifyOwned)=True))
ORDER BY [Movie Collection].OwnedDVDTitle;

For the Detailed Form (the one that will show the details of my
movies), the Record Source was "Movie Collection," which was the table
that holds my movie information.

For the sake of confusion, I didn't list all my tables here, as I have
about 10+ tables (some are joining tables for Screen formats, Actors,
etc) that all link to the main table, "Movie Collection."

> What is the Control Source and name of the textbox?

The name of the textbox you suggested for me to make was called
"MovieLink."

The Control Source of the textbox originally was SQL code listed as
follows:

=Forms![Movie Owned Main Form]![Movie Collection Query subform].Form!
OwnedDVDTitle.

John, this code originally led to my previous post. However, I changed
it to the following after reading your questions:

=Forms![Movie Owned Main Form]![Movie Collection Query subform].Form!
OwnedDVDID

After changing it, everything worked.

> What is the Master Link Field?

The Master Link Field (before and after my previous post) was
"MovieLink"

> What result are you getting, or not getting that you want?

Before my previous post, My datasheet form worked, and the suggested
textbox - MovieLink - worked.  The Detailed form was not populating
against the datasheet form; it was only pulling from my table "Movie
Collection."

After rereading your post and making the changes, everything worked as
you suggested. I just failed to link to my primary key.

John, thanks for your assistance, as it has helped me think through my
processes.

0
Chuck
7/3/2007 3:12:19 PM
On Jul 2, 11:13 am, Bob Quintal <rquin...@sPAmpatico.ca> wrote:
> Charles.Pierrot...@gmail.com wrote innews:1183385077.914254.147240@g4g2000hsf.googlegroups.com:
>
>
>
>
>
> > Hello everyone!
>
> > I need some major assistance on a personal project.  I've been
> > stuck on the whole subforms issue (not that I don't know how
> > they work).  In any event, I've been creating a personal DVD
> > collectoin database, and have done fairly decent until now.
>
> > I have a main form that I want to use and display the same
> > information in two different ways. On the left side of the
> > form, I want to use a query (subform) to display a list of all
> > the movies that I do own.  I on the right side of the form, I
> > want to have another subform listed to detail all the
> > information of the selected movie on the left. Furthermore, I
> > want the information on the right to change according to the
> > selected movie on the left subform.
>
> > Any suggestions?
>
> > Please let me know if any more information is needed.
>
> > Thanks!
>
> > Charles
>
> You should use a listbox, not a subform, on the left side of
> your form. Then you set up the subform on the right side of the
> form..The link parent field for the subform is the name of the
> listbox.
>
> --
> Bob Quintal
>
> PA is y I've altered my email address.
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com- Hide quoted text -
>
> - Show quoted text -

Bob, I tried this also and it worked.  And actually, it has helped me
figure out my small error I had in John's suggestion.  I just had to
make sure that I was using my primary key to make it work.

So in the end... I have two ways to display my information and I
learned something in the process.

Thanks Guys!

0
Chuck
7/3/2007 3:14:28 PM
Reply:

Similar Artilces:

price list issue
Is there a way to manually enter the Price Per Unit when adding a new Opportunity Product? There is no set price for the product we are dealing with. Picking the product from a list is no problem, I just don't want the prices to be a set number. Right now the PPU is filled in based on quantity and the price that is entered in the product list. No.You cannot enter Amount for a rpoduct in the Opportunity stage but definitely during the Quote, Order stage, you can manually add the price for an existing or a new product. You'll have to get this customized if it is Important i...

Reservation Form
I have an active website for my business. I built it in Frontpage 2002. It no longer will send email through the settings I used ( Reservation form) and I cannot get it to take any of the settings I give it. I do not think that my knowledge is sufisticated enough. And, I don't think that I am entering the information completely enough. I am using a simple form with a single enter button. Can you help? May be possible. -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression Web "FrontPage 2002 on windows XP" <FrontPage200...

Auto populate a form form an open form
Hi I have a main form with customer names and addresses and would like to add a control button on this form which opens up another form which is used for recording telephone calls on. What I have been trying to do is auto populate this call log form with information from the main form ie name and address? Any thoughts Thanks Chris Chris, Please don't re-post the same question twice. You have to be patient and wait for a reply. Responders are volunteers, and you may not get an answer right away. Posting twice causes some people to respond to the first post, while others are ...

form pozition on screen
I would like to find form position on screen. It's similar to DoCmd.movesize, but I want discover "parameters' for form position (left corner, top corner, etc) Are you saying that you want to find out what the current position IS? If so, you can use something like this: MyFormLeftVariable = Me.Left MyFormTopVariable = Me.Top MsgBox "My Form is at " & MyFormLeftVariable & VbCrLf & MyFormTopVariable Or however you want to use it. -- Bob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com ___________...

copy properties Under forms
Hi, I'm wondering if someone can help me with something on copying properties. I've checked the access help but can't find anything there. This is what i want to do. I'm copying text boxes, labels that has caption, name and other information in the properties that i want to keep when i copy the information to another tab on a form. Is there a way i can copy the property information without doing alot of manual work by going into each text or label box. I hope this makes sense. thanks for you help in advance. Keith When you copy a control, everything about the cop...

What is the purpose of 'Dummy' window in the Command forms
I am wondering why GP has Dummy window with title "~internal~" for the Command forms. For example Command_Financial form has Dummy window Do I need to create Dummy window for my Command forms. If so why I need it. Any comments appreciated!!! Hi Mandeep, The Dummy window is there as a placeholder. It really doesn't do anything, but should be there in order for the form to work properly since your form needs to be open for the commands to be available. The title ~internal~ just prevents this window from showing up in the Security assignment windows. Make sure that...

Cannot open the Insert object (Pdf file) form Excel 2000(9.0.8968 SP-3)
Dear All, I am no idea why I cannot open the embedded object (Pdf file) inside Excel file which using Windows ME. Once clicked the object icons, then it shows the error message likes " the embedded object cannot be opened by the source application" I used the Adobe reader 6.01 as the source application. Actually, I searched the related forum from the Internet. However, I cannot solve the problem. Anyone helps? Thanks tlee Hi, I can't test 2000 in ME, but it works fine in 2003 under XP. -- If this helps, please click the Yes button. Cheers, Shane Devenshire &q...

SBS 2008 RRAS (VPN Issues)
We have a new user that needs VPN access to the network. He has a laptop that he will be using at the office and on the road, otherwise i would have him use RWW which runs beautifully. I enable VPN through the SBS console. Our router has port 1723 forwarded and GRE47 forwarded. I can make the connection from a client computer to the server. After this point I can not access any resources through IP or UNC. I can not ping any computers either on the LAN side. The client also has a different subnet than the lan. When the client connects I can remote in to the server and open RRAS a...

Form class module for non-existent form
Hi, After copying a form with a class module, something went wrong. I now have a class module for the new form, but the form no longer exists. I am unable to remove the in-limbo class module. I want to use that name for my form, which is not possible as long as that class module is in the way. How do I get rid of the in-limbo class module? I've tried repairing tha DB as well as "msaccess /decompile" but it hasn't helped. Anything else? Thanks, Kjell Kjell, A class module is not part of a form, but a separate module. It sounds like your 'in-limbo' module is...

Setting the Windows Cursor during Form Processing
hiya gurus I would like to force the mouse cursor to immediately become an hourglass when some long processing/quering commences on a form. it appears that it takes some time for Access to show the hourglass and usually only after the user clicks the form a couple of times because there appears to be nothing happening... Is there an easy way to do this from within Access.. I have done it in VB6 using Me.MousePointer = vbHourglass but this does nto work in Access.. any suggestions? cheers Jeff mmmmm Screen.MousePointer = 11 guess this does it? "jeff" <jeff@work...

Position 2nd Form according to 1st Form
I have 2 Forms. When the 1st Form is openned and want I open the 2nd Form, I want it to position itself about 15cm form the Left and 20cm from the top of the 1st Form. I am using Access 2003, Thanks. "AY" <AY@discussions.microsoft.com> wrote in message news:CFA3A4B5-36D9-4A20-AB57-601290155335@microsoft.com... >I have 2 Forms. When the 1st Form is openned and want I open the 2nd Form, >I > want it to position itself about 15cm form the Left and 20cm from the top > of > the 1st Form. I am using Access 2003, Thanks. You should be able to use Nicole Calinoiu...

TOURNAMENT FORMS
Need tournament draw sheet single elimination template. You may find some old NCAA basketball tournament forms out on the web. Try http://google.com HHSTENNIS wrote: > > Need tournament draw sheet single elimination template. -- Dave Peterson ec35720@msn.com ...

Trying to delete form border, and it deletes all borders
I made a form with several individual areas that have borders. At the end I decided to try a border around the whole form. Now that I don't like it, I was trying to delete the form border, but it deletes all the borders in the form as well. How can I just delete the border around the form and not the rest of the individual borders? I'm actually on a different computer, because of the printing, will I be able to undo my way out of it maybe, or do I have to be on the computer where I made the form. One more question, will the form retain the undo feature for ever, or will it stop ...

OL2002->OL2003 migration issue
OL2002-2003 in a Microsoft Exchange Server 2003 environment. Public Folders used for incoming e-mails from outside the company. In OL2002, displaying and customizing the OL bar, when a new messages arrives in a Public Folder, I see the usual bold (1) near that folder's icon. In OL2003 the OL bar is no more, replaced by the "links" view, which I think it's better, but nothing appears if a new message arrives in a public folder, even if, of course, there is a link to that folder in my "links" view. Is there any solution? thanks k karamatic wrote: > OL2002-200...

Run Macro only if certain form is open
I have programed a maco to open one of various forms depending on criteria on an open form. Is there a way to run a "follow up Macro" based on which form opens? In other words can I run a macro based on wheather a certain form is active? -- Thanks, Chuck Take a look at the RunMacro Method of the DoCmd object. You can have it as part of the OnLoad of the form in question. Chuck wrote: >I have programed a maco to open one of various forms depending on criteria on >an open form. Is there a way to run a "follow up Macro" based on which form >opens? In other w...

Forms and Input Data
I created a report form on Sheet 1 and a set of input data on subsequen Sheets 2, 3, ... link to the report. The report is to show informatio on either of the data I select. Are there simple steps for me to pick either set of data I want t display on the report? I've thought of a pull-down menu so that if select "1", the report will show data set "1", and so on. Yet I don' know how to do it. I tried the "replace" command by highlighting al the cell in the Report sheet then type "2" in place of "1" to replac the data set then hitting...

Modal form opens on startup
Evenin' - I hope this doesn't come across as stupid, but I'm almost completely unfamiliar with Access. A client of mine has an Access 2000 database containing some business information, and he'd like to have me import it into Quickbooks. The problem I have is that I cannot get to the information to export it from Access. When the file is opened, I get a (I presume) modal form, configured as a 'splash screen' type of thing. Has my client's logo, and the name of the fellow who wrote the Access app. Click that, and it closes, then opens another form for...

Login issues
After logging into the Bus portal, I go to SITE SETTINGS (we just upgraded to 8.0 with portal and snap in for sharepoint) Manage Business Portal Users, Prompt again for credentials and select add new users. My problem is the screen is too small and I cant resize it to make correct selection. Any thoughts out there to reolve? Hi I am not too sure about resizing the add user wizard. You can add users using the c:\Inetpub\wwwroot\bin\SecuritySetupUtility from the Business Portal server. Regards James "JCooper" <JCooper@discussions.microsoft.com> wrote in message ...

how to solve "Non-modal forms cannot be displayed in this host application"
Hi, I am trying to make a modalless form in VB6 that is compiled as an ActiveX DLL. When i use VC6 to instance the activex DLL, my problem appears that "406 Non-modal forms cannot be displayed in this host application from an ActiveX DLL, ActiveX control or Property Page." I have my form in modalless style in VB6 and they should be instanced in VC. Does anyone know how to get this to work ? Many Thanks, Xiao http://support.microsoft.com/default.aspx?kbid=176468 -- Regards, Nish [VC++ MVP] http://www.voidnish.com http://blog.voidnish.com "arbidol" <arbidol@tom...

Temporary Form with 2 Sub form Update Main Form And its Sub form ?
I have 2 table both are exactly same PatientRecordTransTb And PatientRecordTb I know many programmer don’t like TempTb, but in my case I don’t trust some one to mess with my Main record table. So simple solution is make tamp table and after review I click to transfer all records from temp Table to main Table So I have two forms . PatientRecTransFm record sources = PatientRecordTransTb PatientRecordMainFm record source = PatientRecordTb PatientRecTransFm has 2 button AddRecord And Delete Record Here is a short story of my code (NOT A Actual Code) mySQLString = &quo...

Customization to a Contact Form Does NOT Stick
Everytime I try to add a field in a Contact form, the change does not stick. I have administrator rights, followed the instructions to customize a form to the t. The instructions entailed going to: Home -> Settings Settings tab -> System Customization Record Management -> Contacts Add Fields -select fields to add ok - > save work On the CRM server Start -> Programs -> Microsoft CRM -> Deployment Manager Right click: Deployment Manager -> All Tasks ->Publish Customization Select form customized Add Finish OK Restart IIS After performing these steps, I get b...

I need book lending forms
Please I need your help, I'm looking for book lending forms in order to keep control of which books I'm borrowing and when they have to be returned to me. Thanks ...

Using list box to open forms
I have a list box that lists all the forms in my database. I would like a user to be able to double click on something in the list box, and have it open the corresponding form. Any help on how to do this would be appreciated. Thanks. On Wed, 24 Oct 2007 16:35:22 -0000, lecoughlin@gmail.com wrote: > I have a list box that lists all the forms in my database. I would > like a user to be able to double click on something in the list box, > and have it open the corresponding form. Any help on how to do this > would be appreciated. > > Thanks. Code the list box Double-Cli...

CRM 3.0, OWA and ActiveSync Issues
I have taken over the support of server that is SB2003 with MS CRM 3.0 installed. When I try to access OWA from either outside or inside, I get page can not be found. CRM seems to work fine. I am not familiar with CRM at all. I looked in IIS Manager and see that CRM 3.0 is the default website (default web site naming has been replaced with CRM 3.0). I see the Exchange and EXCHWEB, etc under the CRM 3.0 top level site. What do I need to look for? I am at a loss. TIA! Clay The default (and typical) CRM installation has the CRM website running only over port 5555. This means that even as a d...

from sub form to main form
Hope someone can help on this. I have an a form with a sub form and I’m trying to get some calculated results From my sub to show up in my main form. The Main Form is Job_Sheet_2 The Sub Form is work_hours_sub On the sub I have the following fields that are populated from a query. The criteria for the query comes from a combo box on the main form. JobID EmployeeID StopDate HundredTime The following are field that I added Labor_charge { Fixed Value} Extended { =[Labor_Charge]*[hundredtime} In the footer of my Sub I have the following Text12 ...