Search results

Thanks Dave. The table I'm reading and wanting to pivot has had all the work done on it, so this is purely to produce a report which will allow a drill-down for those who require it. If there is a way to achieve this, I would appreciate your help.

Thanks guys for all your contributions. Eventually found the solution. I put my 'check dates' coding (to establish the background colour) immediately after I've established that a record has been found, i.e. when searching for my key field, I get a 'key found' situation. Sounds obvious now.

I've tried using the "Form_Current()" event (I think I've tried most logically-sounding events), but it dies. I have to save all the dates from the form in an array and because of null data in some dates, it crashes.

Because of 'future-proofing', I'm using VBA controlled by events behind the fields rather than standard conditional formatting. Although that should make things easier, don't you think! I'm calculating 'number of days' between various dates in the recordset and then, depending on the values...

Because of 'future-proofing', I'm using VBA controlled by events behind the fields rather than standard conditional formatting. Although that should make things easier, don't you think! I'm calculating 'number of days' between various dates in the recordset and then, depending on the values...

The user selects a record (on the form header) via a key entry, the record is selected and the data is displayed on the form detail. I want the backgrounds determined by some VBA behind the date fields at this initial stage. At the moment, I can't find an event to do this. Once you start to...

I have a situation where, on loading a (new) record, I want to do some conidtional formatting (using VBA) to set the background for some date fields ("RAG Status" - Red/Amber/Green, depending on other values in recordset). When tabbing through the fields I can get the various events to react...