Salakhetdinov Shamil
mcp2004 at mail.ru
Fri Dec 13 14:52:17 CST 2013
Hi John -- <<< OTOH I have a job (for IBM no less) maintaining Access databases. I am not allowed to "abandon" them. ;) >>> Yes, I know. Good for you - I guess you should get a good retirement plan working for them - lucky man! Better stay there, don't abandon nor "buggy" MS Access nor wealthy IBM ;) So to "effectively" workaround the issue you'll probably have to use a subform with an unbound parent "search" form as it was already proposed here. Thank you. -- Shamil Friday, December 13, 2013 3:11 PM -05:00 from John Colby <jwcolby at gmail.com>: >Shamil, > >Thanks for validating the bug. I am using Windows 7 and Access 2007. > >Which tells me that they haven't decided that bugs are an important >thing to work on, even in 2013. > >Yes, on abandoning. > >OTOH I have a job (for IBM no less) maintaining Access databases. I am >not allowed to "abandon" them. ;) > >On 12/13/2013 3:05 PM, Salakhetdinov Shamil wrote: >> Hi John -- >> >> I didn't know about this bug, sorry. >> >> Just out of curiosity I have: >> >> - created a bound test form, >> - set its recordsource to filter out all records (ID = -1); >> - set AllowAdditions = False; >> - created a search textbox named txtSearch in the form's header; >> - created a search value copy textbox named txtCopy in the form's header; >> - set OnChange event procedure to >> >> Private Sub txtSearch_Change() >> txtCopy.Value = txtSearch.Text >> End Sub >> >> - opened test form in Normal view and typed a char in txtCopy textbox - *bang* >> >> 2185 - You can't reference a property or method for a control unless the control has the focus. >> >> In my test I have used Win8 and MS Access 2013. >> >> There seems to be no effective workaround of this bug. >> >> This is a typical bug case one of many others, which forced me to abandon MS Access/VBA development. >> >> Thank you. >> >> -- Shamil >>