Recent content by Tom Robinson

SetFocus to a button doesn't fire the button's Click event. To do that you need call the button's event handler directly. To do this from another form, you need to change Private Sub NavigationButton113_Click() -to- Public Sub NavigationButton113_Click() and then you can do...

Your loop thru the recordset assigns rs!InvoiceAddress to afiles, but then does nothing with it until the loop is finished. At that point, afiles holds the value for the last record only!

Table relationships are a bit of a mess when you have a split database, because you can define relationships in both the frontend and the backend. If you want relationships to work reliably, use a SQL Server Express backend (it's free) and define the relationships there. I don't use any...

Although you can't use the RGB function when defining a constant, you can use a #bbggrr format like this: Public Const intCanary = &H99FFFF

ellenr I just had the same problem with using "Alternate Back Color" on the Detail. Repaint and Refresh didn't fix it. The problem occurs sporadically when you do a DoCmd.FindRecord in code, or use the Find feature on the ribbon. The solution is to replace FindRecord with: Echo False...