Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Posts
    28

    Unanswered: ComboBox / Query Problem!

    Hi
    I was wondering if there's a simple way for this:
    I have a form with two comboboxes and depending of what you select in combox1 the data that will appear in comb2 will change.
    Everything works fine if you use it once but if I change the value in combobox1 when I click in the combobox2 instead of getting a new set of values i get the same as before. If I close the form, reopen it. It works again but only for the first value.
    I know it would be easy with vb code but I reckon that access probably has simple way of doing this, any chance of updating the form or anything like that?
    Cheers

  2. #2
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    can use this in the AfterUpdate Event of the parent combo...

    YourChildComboName.Requery

    Edit: Sorry didn't read your last line. Not sure of any other way of doing it.
    Last edited by cpgospi; 02-24-05 at 17:47.

  3. #3
    Join Date
    Dec 2004
    Posts
    28
    thanks cpgospi

    I guess I´ll stick to the code

Posting Permissions

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