Hi,
I have a Form, frmDailyActivity_Alternate, on which I use two Combo boxes one to Filter the other.
cboClient allows for a selection of a Client and then based on this selection cboCode should only show the Codes that are applicable to the Client selected in the cboClient combo box.
If the two combo boxes are unbound then these two Combo boxes work as described. Once they are bound, cboClient is bound to ClientId and cboCode is bound to CodeID, they no longer work.
What happens is the once the client is chosen from the drop down of cboClient, the cboCode selection does not update.
In the code I do have under cboClient_AfterUpdate()
me.cboCode.requery
but to no avail.
I have also tried me.dirty = false here but this too does not seem to help.
This problem only happens in the Add a new Record mode.
I have attached a zipped copy of this test database...it is all fictional, in the hope that you can help me solve this issue.
Any pointers, suggestions would be most appreciated.
Thanks,
Tom.