Page 3 of 3 FirstFirst 123
Results 31 to 39 of 39
  1. #31
    clean32 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    51
    Quote Originally Posted by Bob Fitz View Post
    Ok



    No change in the subform. Now I see your problem.

    I think I know how to overcome it. I will have a play with it and post back shortly.
    big thanks an a beer if you do, seems a simple problem but its doing my head in. tempting to go back to Ver 1.2, but that's a problem with XP

  2. #32
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Replace the Record Source property of the subform with this:

    SELECT Item.Item, Item.area, Item.[plant type], Item.[commision date], Item.[supplyer codes], Item.statis, Item.notes, Item.Date FROM Item WHERE (((Item.area)=Forms!main!Combo0) And ((Item.[plant type])=Forms!main!Combo2));
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #33
    clean32 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    51
    Quote Originally Posted by Bob Fitz View Post
    Replace the Record Source property of the subform with this:

    SELECT Item.Item, Item.area, Item.[plant type], Item.[commision date], Item.[supplyer codes], Item.statis, Item.notes, Item.Date FROM Item WHERE (((Item.area)=Forms!main!Combo0) And ((Item.[plant type])=Forms!main!Combo2));
    brilliant, that works.

    BUT why? what bugs me is that in ver1.1 it was so much easyer

  4. #34
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Sorry to bring bad news, but I'm not sure this is the complete answer to your needs.

    If you need to add new records in the subform we will need to find another solution.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #35
    clean32 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    51
    Quote Originally Posted by Bob Fitz View Post
    Sorry to bring bad news, but I'm not sure this is the complete answer to your needs.

    If you need to add new records in the subform we will need to find another solution.
    cool, just make up a new form, ADD RECORDS LOL

  6. #36
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    No need for a new form

    It can be done on this form, we just need to make a few changes. I've just tried it out and it seems to work fine.

    Would you like me to post the required changes?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  7. #37
    clean32 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    51
    Oh yes please

    bear wood etc

  8. #38
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    OK

    Try this out:

    Remove the Master and Child Link properties because we won't need those after all.

    Put this in the After Update event of both combo boxes:
    Me.Item1.Requery

    In the Default Value property of the textbox called "area" on the subform:
    =[Forms]![main]![Combo0]

    In the Default Value property of the textbox called "plant type" on the subform:
    =[Forms]![main]![Combo2]

    I don't think I've missed anything but if you have any problems, post back.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  9. #39
    clean32 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    51
    brilliant, that worked well

    if your in Adelaide that's a beer for you

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-04-2011, 05:04 AM
  2. Combo Box Filtering between Forms
    By andrew_ww in forum Access
    Replies: 3
    Last Post: 12-30-2009, 11:06 PM
  3. cascading combo boxes on Continuous Forms
    By Jerry8989 in forum Forms
    Replies: 0
    Last Post: 10-12-2009, 10:02 AM
  4. Replies: 4
    Last Post: 04-01-2009, 08:49 PM
  5. Working with Two Combo boxs
    By Della Smith in forum Database Design
    Replies: 2
    Last Post: 08-01-2008, 02:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums