Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
record data after cbo update
- Thread starter shy216
- Start date
TheAceMan1
Programmer
How are ya shy216 . . .
Your post is vague! Be more specific and you'll get answers . . .
See Ya! . . . . . .
Your post is vague! Be more specific and you'll get answers . . .
I'm not sure if this is what shy216 is after, but I have a similar question.
I have an unbound cbo list that I have updating another bound cbo list on the form. Everything works, EXCEPT, when I select a value in the 1st unbound cbo list, the 2nd bound cbo list doesn't update with the new query dynaset. If I'm in Form View and make a quick swap to Design View and back again, then the 2nd control is updated.
More details:
1) Unbound combo box has its result stored into cboClubName (works).
2) a 2nd bound combo box uses cboClubName to generate its list items to only those records that match (i.e. Select tblTeams.sTeamName FROM tblTeams WHERE tblTeams.sClubName = cboClubName
The problem is that item two doesn't update its list based on a new selection from item 1. I have to jump out of form view and back again so that it is updated.
How do I force an instant update of the list values in item 2) above immediately upon a change to the selection in item 1)?
Thanks for the help!
I have an unbound cbo list that I have updating another bound cbo list on the form. Everything works, EXCEPT, when I select a value in the 1st unbound cbo list, the 2nd bound cbo list doesn't update with the new query dynaset. If I'm in Form View and make a quick swap to Design View and back again, then the 2nd control is updated.
More details:
1) Unbound combo box has its result stored into cboClubName (works).
2) a 2nd bound combo box uses cboClubName to generate its list items to only those records that match (i.e. Select tblTeams.sTeamName FROM tblTeams WHERE tblTeams.sClubName = cboClubName
The problem is that item two doesn't update its list based on a new selection from item 1. I have to jump out of form view and back again so that it is updated.
How do I force an instant update of the list values in item 2) above immediately upon a change to the selection in item 1)?
Thanks for the help!
Ahhh, its amazing what happens when you RTFM (well, the FAQ in this case). I found the answer to my question at
TheAceMan1
Programmer
How are ya NYvbc . . .
Its not good to mix posts . . . For your benefit, start a new thread and expose your specific porblem to the forum. At least this way you have full exposure to your specific problem! . . . and considering the great many guru's we have here . . . you owe it to yourself to do so ;-)
See Ya! . . . . . .
Its not good to mix posts . . . For your benefit, start a new thread and expose your specific porblem to the forum. At least this way you have full exposure to your specific problem! . . . and considering the great many guru's we have here . . . you owe it to yourself to do so ;-)
- Status
