Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking Fields on a Form (Access 2003)

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  2. #2
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Fields on a Form (Access 2003)

    Sorry Hans. I do have the mdb down to 87kb but I don't see a place on the post page where I click to add an attachment. Having never done this before could you advise? Thanks.
    Bob

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking Fields on a Form (Access 2003)

    Below the box in which you compose a reply, you'll find a box labeled "Attach a file - 100k Max." and a Browse... button. Click this button to select the zip file.
    Warning: don't preview your reply after specifying the attachment!
    Attached Images Attached Images
    • File Type: png x.png (13.8 KB, 1 views)

  4. #4
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking Fields on a Form (Access 2003)

    The scenario. There are 3 tables in an mdb: Customers - One table (PK is Customer ID); Orders: - Many table (PK is Orders ID Foreign key is Customer ID and it's a combo box); Materials - Many table to the Orders table. A query created which contains all fields in the Customer & Orders tables; the only field not included is the PK in the Customer table. Using the wizard, a form is created that has the Query info as the main form and the Materials query as the subform. When finalized, the user can change order and materials info by scrolling with the wheel or using the navigation bar. My dilemma is this. When I use the Customer ID combo box to search for an existing customer, the only fields that change are the customer's; the orders and the materials info don't change. Any ideas as to why or how to fix this so, when the user changes the customer from the combo box, everything else changes to correspond? Thanks in advance.
    Bob
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Fields on a Form (Access 2003)

    Thanks Hans; I just didn't scroll far enough down the page. I believe the zipped attachment is posted ok. Just a minor detail that doesn't affect the problem; the subform is created by merging the other two fields together in a query. Thanks in advance for any hints or solutions.
    Bob

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Linking Fields on a Form (Access 2003)

    Attachment?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking Fields on a Form (Access 2003)

    The Customer # combo box on the main form is *not* used to search for a customer, it changes the customer for the current order!

    to search, you need an unbound combo box. In the attached version, I have added such a combo box to the form header; to see how it works look at the After Update event procedure in the Visual Basic Editor.
    Attached Files Attached Files

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking Fields on a Form (Access 2003)

    Bob attached the zip file to the first post in the thread.

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Linking Fields on a Form (Access 2003)

    I see Hans has ably replied to you.

    A couple of things:
    1. the # in the customer number field, i tend to stay away from those special chars.
    2. have you an aversion to VBA code, i see you use macros.

    Cheers

  10. #10
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Fields on a Form (Access 2003)

    Pat:
    You're right; I do have an aversion to VB; I've taken a few courses in it and I discovered it wasn't my "friend". But the macros in this database are part of an exercise I was conducting. Thanks :-)

  11. #11
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Fields on a Form (Access 2003)

    Hans: I downloaded and opened your spreadsheet with the search unbound control. Unfortunately, when I try to select another Customer, it gives an error. But, not to worry as you've answered my question. Thanks much.
    Bob

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking Fields on a Form (Access 2003)

    If you'd still like to get the combo box to work, you can try this:
    - Press Alt+F11 to activate the Visual Basic Editor.
    - Select Tools | References...
    - Scroll down until you see Microsoft DAO 3.6 Object Library.
    - Tick the corresponding check box.
    - Click OK.
    If that doesn't help, I'm not sure what causes the problem.

  13. #13
    New Lounger
    Join Date
    Feb 2009
    Location
    Cleveland, Ober�sterreich, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Fields on a Form (Access 2003)

    Hans,

    I am having a very similar issue with Access 2003: I am working with Part Numbers and Job Numbers (each specifying various additional parameters)- I have a main form that I'm trying to add some subforms to. The main form is searching by Job Number and returning data, while the first subform is adding a single piece of information that I can't seem to query smoothly (raw material stock size). I have dragged the subform into the main, though so far it remains completely independent (searchable by Part Number). I'm attempting to have it populated with whatever part number is defined (by Job Number) in the main form.

    Can you provide a description of the steps you went through? I've looked your attachment but so far no luck. Thank you.

    Matt

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking Fields on a Form (Access 2003)

    Welcome to Woody's Lounge!

    To link a subform to the main form it's on:
    - Open the main form in design view.
    - Click once on the subform to select it.
    - Activate the Data tab of the Properties window.
    - In the "Link Child Fields" property, enter the name of the field in the subform that links to the main form.
    - In the "Link Master Fields" property, enter the name of the corresponding field in the main form (the field linked to).

  15. #15
    New Lounger
    Join Date
    Feb 2009
    Location
    Cleveland, Ober�sterreich, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks, Hans, it worked great and I've added more complexity. Now another issue has come up through the subform additions- Two separate forms are using the same functionality (until I learn more)- one looking up data by Job Number and the other by part number. One works fine and the other has an issue (though the subforms are the same). Now, one of these is prompting me to "Enter Parameter Value" for the field that is the Parent/Child link between the form and its subform. What could be causing this? I've exhausted what I know in terms of checking the query relationships and form links...

    Thanks, and congrats on the successful upgrade. The site looks great.

    Matt

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •