Recent content by toddtharp

set the combo's limit to list to false. On the after update event, check to see if the combo box has a value, if not not, insert the new value into the table using docmd.runsql() Sub cmbOx After_Update if isnull(me.cmbOx) then 'Docmd.setwarnings false Docmd.RunSQL( "INSERT INTO...

Michael, I always look to MS first, after help I usually check their kb, then I come to places like this to get help, not snark. But thanks anyway, pal. Payback, I discovered the problem with the bracketing was from the default rowsource on a particular list box. I hadn't changed it, and...

Looking to see if anyone has had this problem before. I've got a form with a tab control on it and several subforms on different tabs. I have events coded On_Open, On_Activate and On_Current. Recently, when opening this form, I got an error talking about a bracketing error on a field name...

Further update: I've discovered that the list box must be the focus to be able to set the listindex property and have the highlighted row change to that index.

Okay, further problems - I'm now cycling through the rows in the list box and grabbing the listindex number of the record I want. However, when I attempt to set the listindex property of the listbox to that number (and thus selecting it), I get the following error: '7777' - You've used the...

Yes there is a way. You do it by setting a flag in a lookup table, then in your onTimer event, check to see if the flag is thrown, if so, docmd.quit. You may need to have an additional field identifying the user, I don't, mine is global and once set it forces all open databases to close. I...

Okay, update - I can select a row in the list box by setting the listindex property to a number. Is there a quick way to get at an listindex number if I'm looking for a particular string in one of the columns? Thanks

I have recently changed a list box to Extended multi-select and other bits of code which reference it are now breaking. I have no problem getting at the data values in the list box, but haven't been able to figure out how to SET the value of the list box programmatically. I have form with two...