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
842 Views

Similar Articles

[PageSpeed] 5

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:

Help filling in form from 2 different tables
I have two tables, CustomerData and EmployeeData. CustomerData has all the address, phn, name, empid# of last employee to help em and custid (primary key) and employeedata has name addr phn and empid (primarykey) I have a combo box that pulls up custdata (by Custid sorting by Lastname & ", " & Firstname) I wanna do an Afterupdate event to fill out the following textboxes (based on the Custid it fills out the Lastname, Firstname, Address, Phnnumber) and then based on the Empid of the last Employee that helped em it will fill out the textboxes witht he first and last na...

syntax for tab on a form
I constructed a search routine for a database. It is a form with a subform as a datasheet. The form has the search button and a reset button and various criteria boxes. Everything appears to work fine! The above was just a test or practice. I am very new to access. Now I would like to begin the finished product and the above routine would be on the first tab of a new form. The above search routine doesn't work and I can not find the proper syntax anywhere to move it to a form with a tab. Below are two lines from the search routine if that will help any Me.frmsubAllR...

Excel Data printed out as a Form
I have data in an Excel Spreadsheet where each row of data pertains to a single family in our church. the information was downloaded from our online data base and Excel is the only method available for export. I would like to have each row of data print out as a form (one row of info on a single 8 1/2 x 11 page). Does anyone know how to do this? Or if it is possible? Becca, Use a Microsoft Word mail merge. It can use the Excel list, and you can make it as pretty as you like. Exactly what you need. You can also use an Access Report (printout), but if you're not familiar wit...

Outlook /Calendars Delegation Issues.....
Maybe this is a question for the outlook or exchange user groups, but I just setup SBS2003 with outlook 2003 on all 5 clients. I setup one (primary) of the clients outlook calendar to allow delegate rights to the other four, which works great. My problem is that when the "primary" user goes in and creates an appt,event, meeting or even just updates anything in their calendar the other four recieve updates of the changes. I've looked at how to stop this but cannot find anything. Anyone have any Ideas. Thanks in advance for your help. R Use a public calendar instead. ...

required field in a form.
I have a form that consists of a field that if it is double clicked it will enter Now(). I need to make sure that the user doesn't miss this field and cannot go to the next record until the field has Now(). I have tried the following... Before Update, After Update and the validation rule. I don't get any errors but I can still go to the next record. Please Help!!! I am sure that this is really easy and I probably did something real stupid. Can you give me an example of the best way to do it. The field that I need to require is Post_Called_Customer The Form Name is Main Info And...

Sub Form not showing all records
I have created a form (PartSuffixSubFrm) that shows Part Number, Suffix and a check box from the table PartSuffixTbl. When I open the PartSuffixSubFrm as a Form all of the Part and Suffix records in the table show up. But when I include this as a subform on my LocationFrm the PartSuffixSubFrm only shows the first Part Number and it's Suffixes. I cannot see, nor reach, the rest of the records. Can anyone tell what I have missed based on this explination? Never mind - I am actually going a different way on this project. But for others found the Parent Child relationships are what...

Password Issue
Don't get me wrong here, I have received plenty of great information from MVP's and other regarding MS software, but to make us all sound like idiots because we used the suggested password system for a product is unacceptable. MS specifically tells you it is highly recommended to use Passport. Now while we all wait for the fix, we get to listen to all of you tell us how stupid we are for even using it in the first place. Personally, I can get around using it for now, but it is rather annoying that it is taking this long. Funny thing, I had always used Quicken in the pas...

"the path is not of a legal form" during CRM install
Hi all, On a couple different servers while installing various CRM components I've run into an error that halts installation. On the "Select Installation Location" screen for the CRM outlook client and the Microsoft Dynamics CRM Data Migration manager setup I get a dialogue box with a big red X that reads "The path is not of a legal form" with an OK button. Hitting OK returns to to the installation location screen, but if you hit next it just keeps popping up, leaving you with cancel as the only option. The illegal path does not seem to refer to the install path...

Copy Attachments from Outlook to a Web Form?
I am looking for ways my users can copy an email (w/attachments) from Outlook and paste it in to a web form / control? If this isn't possible, then I am open to other suggestions, thoughts! Thanks in advance! Pankil. ...

executing code on access forms on different pc's
We have several access databases that we used without any problems for years. All databases are in access2003 format and have forms with VB code behind it. recently we are getting new PC's that cannot execute the forms in (MDE version) databases. It reports missing references. Opening the MDB version is no problem but then it cannot be opened on the older PC's anymore. Both old and new PC's have Office 2003 installed and are running XPSP2. The missing references are 3 files: Comct232.ocx Comdlg32.ocx mscomct2.ocx Does anyone know where these files come from? Could they belon...

Needing help with my first form
Hi folks, This will be my first post so hi. I've been asked to design a Laptop pool form for the company. The form should be able to record who in the company has a laptop and for how long. I imagine this is quite strait forward. the form should have a couple of drop downs and a couple of text boxes to save the persons details. Then, when they save the info, it should enter into that day of a Calendar. If the entry is clicked, i'd like a form to pop up with the details of that person and who made the booking of that lap top etc. That's it. There's not a great deal of info...

Exchange 5.5 mailbox issues
We are currently using a exchange 5.5 server and one of our directors is not getting all his emails sent. Its been when 3 or 4 external users send him email but he does not get it and the external senders get an NDR. The NDR sent to the senders refers to the exceeding storage allocation, but our director is not over the storage limit, as we individually set large limits for the director. It only happens occassionally and the director has said it could be more than the 4 senders, as its difficult to monitor. And today another user who was sent email from the same sender has the same problem...

Copy value of field to other form
How do I copy the value of a field from one form to another form that is not part of a subform relationship? -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200703/1 hi Matt, mattc66 via AccessMonster.com wrote: > How do I copy the value of a field from one form to another form that is not > part of a subform relationship? You can access any form, if it is loaded, with Forms("OtherForm").Form![FieldName] = Me![FieldName] or Forms("OtherForm").Form![FieldN...

Date field behavior differs between forms
I have two forms with seemingly identical date fields. In one, if I place my cursor in the middle of it, the first number I type gets put in the far left of the field. In the field on the other form, if I place the cursor in the middle, it starts typing right where I am. Any ideas? I have thoroughly looked through the properties of each field and each form and I cannot find what is causing this behavior. I would love to get both of them to start placing typed characters at the far left instead of where the cursor is. Thanks! ...

Full Screen Forms in 2007
I recently upgraded to 2007...and I'm not entirely happy. I created all my forms in 2003 and had them all full screen, working the way I wanted clients to see them,. In 2007 I have the ribbon on top and the table/forms/reports/etc box on the left. How can I get the same form behavior I had in 2003? Bruce It's not intutitive, but possible: http://msdn.microsoft.com/en-us/library/bb258192.aspx -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Bruce Rodtnick" <Rodtnick@comcast.net> wrot...

Excel graphing and equation issues
Okay so here is my problem. For work, I have a curve that I need to put into excel and find the equation. So I look at the curve and record data points from the curve into excel. I will then graph the points and it will produce a curve just like the one have on paper. My problem comes when I ask excel to produce equations for the curves. The equations it produces do not match the curves when I enter a value into the equation. Why does this happen or how can I fix it? Make sure you start with an XY chart, not a line chart. Then make sure the equation has enough digits, so apply ...

calculated field from a form to table
Can you take a calculated field from a form and pull it in to a table?? You can but you should not. Instead, calculate the value each time you need it. Stored values are almost guaranteed to get out of synch sooner or later. HTH -- -Larry- -- "Darren" <Darren@discussions.microsoft.com> wrote in message news:4A519CB5-029B-46FF-80B5-22D6FEA0C7AB@microsoft.com... > Can you take a calculated field from a form and pull it in to a table?? Ok, makes sense. If i wanted to do it to get a snapshot and save that in the table, how do you do this? "Larry Daugherty" w...

Issues after upgrade to Exchange 2007
After upgrading to Exchange 2007, we are experiencing these issues: 1. E-mails sent from CRM are not routing thru Exchange to the Internet (we use a forwarding e-mail, and all lights are green within the Router Config Manager) 2. Incoming CRM-related e-mails in Outlook are not automatically tagged with the CRM icon Specific to item #1, we are seeing this error: #27938 - An error occurred while checking for e-mail messages to process in mailbox crmadmin@domain.com. System.Net.WebException: The remote server returned an error: (404) Not Found. at System.Net.HttpWebRequest.GetResponse(...

How can I find out what the firewall issue is on a Printer?
I was having problems reinstalling HP software for my All-In-One printer, and HP Tech support had me add ten or fifteen programs to the Firewall as allowed programs, plus about that many ports. I'm still having firewall issues according to the HP networks diagnostic tool, and the HP software does not "see" my printer on the network. I can go to its IP address in Internet Explorer and see info about its status, etc, and I can install basic drivers for other similar printers and it will print, but not from the Full Software package that I need for OCR scanning. It ...

Time sheet issues
There are three questions I am preparing a time shhet. To strart with I have to prepare a blank sheet and give one sheet for each emlpoyee Here are the blank walls I am hitting 1. I want to format a cell (E2 in my time sheet) in such a way that if enter "1" it should display "January" and so on. How to do it? 2. The First cell of last row (A 34 in my of the time sheet) should have 28, 29, 30 or 31 depending the conditions of E2 and H2 which has month and year respectively. 3. The cells B4 to B34 should have days cooresponding to dates (number) in A4 to B34 They sho...

Subform
I'm having a problem loading data in a subform. The fields in the subform and main form are not bound. I'm using MSAccess 2007 I put VBA code in the "On Load" event of the subform to get records from a table and populate the fields on the subform after the main form is opened from a previous form but I'm getting the message: " MSAccess can't find the form referenced in the VBA code" (referring to the subform, mysubform) . As a test, I put the code to populate the subform (including, as the first line of the code, "DoCmd...

Outlook Contacts always suggests "Custom Form Cannot Be Opened"
Dear All, I have ascertained by searching "Message Class Field" that all contacts in the search come up as found. Therefore I think somehow I have put in place a Custom Form and would like Outlook to go back to using the default / standard form. Thank you for any further Help. Yours sincerely, -- Neil@UK Get http://www.publicshareware.com/download/DocMessageClass.zip and use it to change the message class back to the default. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.sli...

Issue when combining fields
I have combined 3 fields (firstname, lastname, business) in a query to come up with a concatenated field called custname. The only problem is when one of the fields has no data it puts a space in where the data would have been inserted into the string. For instance, if neither firstname nor lastname have data, and business does, I end up with something like (space) Scott's. The problem with this is that if I want to sort alphabetically, anything with a space before it comes up first. Is there a way to fix this? Thanks! Trim(FirstName & " " & LastName ) If Fir...

How do I prevent pictures form moving when adding text?
Right click the picture, format picture, Layout tab, Object position, change to exact. -- Mary Sauer http://msauer.mvps.org/ "Peggy" <Peggy@discussions.microsoft.com> wrote in message news:EA35218F-D1FA-4691-B01E-3D50B2AF3FA9@microsoft.com... > Is there a way when inserting pictures and clipart of have them all wrap the way you want when you bring them in. Some option or setup or something for when you insert pictures? Everytime I insert pictures I need to change the wrap. "Mary Sauer" wrote: > Right click the picture, format picture, Layout t...

Activity creation issues
I have coma across a couple of issues when creating activities: 1) When creating phone call, regardless of the direction, the sender remains as the owner and the recipient the related customer (assuming this is created from within a contact's view). This means that the incoming phonecall is recorded as being sent by one of our staff, despite it being received by them. I have attempted to create workflow to rectify this but it appears to fail to fire (presumably because there is a conflict as one cannot simply get the sender/recipient to switch, resulting in duplicates, and thus e...