Recent content by jch278

Dear dpgttr, Thank you for your reply. Unfortunately it's so long ago now that I can't remember how I resolved it. I must have used some sort of workaround. You can see from my messages that I was finding it pretty frustrating. Anyway I really appreciate that you took time out to get back to...

Why don't you just try it and see that it's the embedded macro generated by the wizard that does the work for the list box (not combo box). Absolutely no more from me after this!

There is no vba code for the form apart from the message boxes that I've added in the afterupdate, current, load and open subs as described previously. It would have taken you 2 minutes to replicate the example I described in my first posting and you would have seen that an embedded macro is...

I've added Afterupdate with a messagebox to the example described in my original . This runs when I change Name3 to Name3x, for example, and navigate from the 3rd to the 2nd record, however now clicking on the first record of the list box (not combo box) still doesn't run the Form_Current event.

Pat, Thanks again for replying. Apologies for my continued inability to see your point, but I'm still puzzled. My form loads at the first record. If I now use the Navigation buttons to move to the 3rd record, say, doesn't this become the current record? i.e. The current record is no longer...

Hi Pat, Thanks for your reply. I'm confused. In your first response you say that " It (the current event) does NOT run when you click into list boxes". In your second you say "Your code is repositioning the form to a new record and THAT is what causes the current event to run" i.e. it...

Hi Pat, Thanks for your reply. You say " It does NOT run when you click into list boxes", however it most certainly does. It's only for the first record that it doesn't and this is after scrolling to and displaying other records. Chris

In a form in Access 2010 when I click on the first entry in a List Box, Form_Current is not executed. When I click on any other entry it is executed. A simple example will illustrate this. Table, Table1 with 2 fields, Id and Field1. Form with List Box created using "Find a record...