Results 1 to 12 of 12
  1. 08-15-2011, 05:35 AM #1
    Paul1762
    Paul1762 is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2011
    Posts
    7

    Combo Box to selectable

    I have create a Form with two combo boxes in it to update a table...

    I have two fields both are combo boxes...

    the first combo box sets the high level value... the second is based on a query that filters from the high level value and re-queries the form...



    my problem is the second combo box brings backs the correct values but is un-selectable...

    can anyone help...

    PaulR
    Reply With Quote Reply With Quote
  2. 08-15-2011, 05:55 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Can you tell what it is exactly that happens when you try to make a selection in the second combo box?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  3. 08-15-2011, 06:00 AM #3
    Paul1762
    Paul1762 is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2011
    Posts
    7
    you can see the correct low level values associated with the high level values in the first combo box...

    but you cannot select any of the low level values...

    thanks
    PaulR
    Reply With Quote Reply With Quote
  4. 08-15-2011, 06:06 AM #4
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Check that the Locked property is set to No.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  5. 08-15-2011, 08:22 AM #5
    Paul1762
    Paul1762 is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2011
    Posts
    7
    no the locked property is not set to yes...

    my lower level combo box control source is based on a query to filter from on the high level combo box

    PaulR
    Last edited by Paul1762; 08-15-2011 at 08:40 AM. Reason: More Information added
    Reply With Quote Reply With Quote
  6. 08-15-2011, 08:41 AM #6
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Is it possible for you to post a cut down version of the db in A2003 mdb format with a little test data?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  7. 08-15-2011, 08:46 AM #7
    Paul1762
    Paul1762 is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2011
    Posts
    7
    sorry,
    I am working in a restricted network with a2003 cannot access internet... I have a2007 on the pc I am using to post... I will try and replicate in a2007 if that is ok...
    Reply With Quote Reply With Quote
  8. 08-15-2011, 09:02 AM #8
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    I have a2007 on the pc I am using to post... I will try and replicate in a2007 if that is ok...
    I will not be able to use it in A2007 format as the latest version that I have is A2003. It should be possible to convert it to A2003.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  9. 08-15-2011, 09:05 AM #9
    Paul1762
    Paul1762 is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2011
    Posts
    7
    I think I have created a test .mdb
    Reply With Quote Reply With Quote
  10. 08-15-2011, 09:27 AM #10
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    I'm sorry to say it but no, that is not an .mdb file
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  11. 08-15-2011, 09:36 AM #11
    Paul1762
    Paul1762 is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2011
    Posts
    7
    yes sorry it was a .accb
    Reply With Quote Reply With Quote
  12. 08-15-2011, 11:05 AM #12
    Paul1762
    Paul1762 is offline Novice
    Windows Vista Access 2003
    Join Date
    Aug 2011
    Posts
    7
    I think I figure it out now... I was using a filter query the wrong way...

    sorry about the confusion...

    many thanks
    Paul R
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Filtered Combo Box in Subform based on Combo Box in Main Form
    By Dip8324 in forum Forms
    Replies: 5
    Last Post: 01-02-2011, 10:09 AM
  2. non-selectable combo box
    By Ted C in forum Forms
    Replies: 1
    Last Post: 06-22-2010, 03:22 PM
  3. Limit combo box 2 values based off of combo box 1 selection
    By jmartin in forum Forms
    Replies: 1
    Last Post: 08-26-2009, 10:45 AM
  4. Filtering subform combo from main form combo
    By MUKUDU99 in forum Forms
    Replies: 0
    Last Post: 08-17-2008, 12:19 PM
  5. Date Selectable limitations
    By Robert_Clash in forum Access
    Replies: 0
    Last Post: 11-27-2007, 09:00 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums