Griffiths, Richard
R.Griffiths at bury.gov.uk
Thu Apr 19 05:49:38 CDT 2007
Hi Access 97 It's been a long time since I've posted here - still take a regular look, even though I concentrate on .net these days. A combination of time without Access and lack of time to play around myself..... but I have someone asking my advice. Scenario.....timesheet screen... header record with continuous subform details. Two combo's on the subform....the second of which needs to be re-queried based on the value in combo 1. This is actioned on the after-update event of combo1. The undesired result is that on previous records in the subform combo 2 is cleared out when combo 1 is re-queried (if the list id different say to the current record). I'm sure I've been here before......but can't get the solution...so all you active MS Accessers..... any clues?? Thanks in advance Richard Griffiths 0161 253 5169 Software Developer