My form has a subform whose recordsource is set to an SQL statement when a command button is clicked (not doubleclick). The problem is the records don't appear in the subform on the first click -- actually they do sometimes but most of the time, it takes two, sometimes three clicks to get the records to appear. I've never seen anything like this and can't for the life of me, pin down why this happening.
Do any tek-tippers have any ideas for me?
Do any tek-tippers have any ideas for me?