Combos

[AdventureBob]

I have 2 combo boxes used to downselect data.
1st is BudgetOwnerCbo (unbound)
2nd is AuthBudgetCodeCbo (Bound to BudgetLineID)

Budget owner forces Auth Budget Code to limit to only budget codes Auth for the slected user. We store a number refering to the Budget Line ID in the budget table based off the down selects. User never sees the Budget Line ID and could care less. Its just "geekiness" to the user. It all works well except....

When the user is looking through the form the 2 fields are blank unless he just updated them. How do I have the fields work in reverse? meaning how do I keep the values associted with that budget line id in Budget owner and Budget code? Ive looked a the ubiquitious http://www.fontstuff.com/access/acctut10.htm and he cheats by hardwiring a case statement for his sync. There has to be a way to do this....

Thanks
BC

[SoftwareMatters]

If I understand your problem correctly I'd say you need to put a requery on the OnCurrent of the form that 'refreshes' the data in the 'filtered' field.

Something like this:

Me!FieldName.Requery

NB: Just replace FieldName with the name of the 'filtered' field.