 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / February 2008One combo box changing another - partial success
I have applied the following solution wherein a choice in Combo box A changes what's available in Combo box B, and it works fine. However, after updating record two and returning to record one, I see that the actions I took in record two have effected teh combo boxes in record one. At first, I thought it was a continuous form problem, but it persists after changing to a single form. Any help is appreciated. I suspect you are using the AfterUpdate event in Combo Box 1 to set the row source query for combo box 2 Try instead to use the ONEnter event of combo box 2 to set the row source for combo box2 based on the parameters found in combo box 1 for that same record. It will reset the rowsource every time you neter box 2. Not just after you have chaged box 1 Tom >I have applied the following solution wherein a choice in Combo box A >changes [quoted text clipped - 9 lines] > > Any help is appreciated. I appreciate your quick response. I'll give it a try. Just to be clear. I am in record 1 I change CmbA to Beverages CmbB refreshes to Water, Pop, Tea I choose WATER I go to record 2 I change CmbA to Fruit CmbB refreshes to Apples, Oranges I choose ORANGES Now I go back to record 1 CmbB has been blanked out - because of the actions I took in Record 2 I'll try your method in the meantime. There's another method on this Microsoft site which doesn't use rowsource, but uses the AfterUpdate event: http://office.microsoft.com/en-us/access/HA011730581033.aspx > I suspect you are using the AfterUpdate event in Combo Box 1 to set the row > source query for combo box 2 [quoted text clipped - 19 lines] > > > > Any help is appreciated. The method on the microsoft site actually uses rowsource but does not use an event. It uses a query with a variable criteria taken from the form. It should work as well. Tom >I appreciate your quick response. I'll give it a try. Just to be clear. > [quoted text clipped - 45 lines] >> > >> > Any help is appreciated. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.