Search results

Yes, AfterUpdate is solution. I wasn't thinking about having to move off the control before Access knew it was "after".

Thanks, Paul. Appreciate this excellent forum... I'm moving from years of Dbase programming (vocationally) given up several years ago as the software stopped evolving, and while I'm wow'ed by all that Access can do, it's a bit overwhelming. Am working through two 700+ page manuals (Access 2010...

Thanks. I try that... thought I did and it only fired with a table/query update. This is just an unbound "grab the value and use it elsewhere" control.

Got an unbound textbox holding a date with an onChange that updates the WHERE clause in the RecordSource to show only records for the set date. Works perfectly if the DatePicker is used, however, if the user enters the date by hand with each keystroke I get an error msg. WOULD YOU... 1) dump...

Thanks Paul & Nigel! The light comes on... seems so obvious in the light of new a day :)

Should have added this line of code from the top of the Module: Global Btns(4) As Variant ' Set to the number of buttons on the msgbox form So is this an array declaration?? Still don't recognize the structure... I'm new enough to Access VBA and it's just enough different that PHP & etc. that...

Is the Btns() an anonymous function?? Can you point me to the correct description for it. It was in a great bit of sample code by forum member r.harrison for his formatted Msgbox: BtnPressed = Btns(MsgBox(.....) Select Case BtnPressed Case Btns(0) etc