Reply to thread

Message: [QUOTE="chopnflash, post: 14149480, member: 116189"] Hi All, Using Access 2003, SP3. I'd like to be able to mark contacts in my database as inactive so, for example, it's not possible for product to be dispatched to a contact (a customer) that is inactive. Any contact marked as inactive doesn't appear in a combo box list since the row source query selects only the contacts that are active. This works fine, however if a record involving this contact is viewed (one that was entered before the contact was made inactive), the combo box is empty - the contact name doesn't appear since they aren't in the list any more. After much searching, I found a partial solution in another thread - [URL]https://www.pcreview.co.uk/forums/combobox-blank-t3960886.html[/URL] I can confirm that this works, but I needed to add Me.Refresh to the end of the code. As expected, this solution does [U]not[/U] work for a form in datasheet view. Does anyone know of a solution that works for a form (or subform) in datasheet view? I've managed to work through most of the issues I've had with Access, however this one has been surprisingly difficult to solve. Please help! [/QUOTE]