Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    8

    Question Unanswered: issues with rowsources and combos

    Hi,

    Does anybody know how to change the rowsource for a combo box but only for the individual record you are on and not for all records?

    The basic problem I have is that I have two combo boxes, the first controls the source of the 2nd one - in the onchange event. However, this seems to effect all records, so that when I change the 1st combo for the first record it correctly alters the record source of the 2nd combo.
    But when I now go to the second record, and change the 1st combo there, it automatically clears the contents of the 2nd combo for the 1st record.

    Any help much appreciated!

    fennis

  2. #2
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    What you have is actually a visual effect.

    The source is changed OK, but your combo box is bound to a field that has a value which is not returned by the row source.

    And you have a continuous form.

    You can only accomplish what you want in a single form, not a continuous one...

Posting Permissions

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