setting recordsource

[John Sh]

I have a form that is used by a couple of different tables.
The form is initially unbound, but when "me.recordsource = stable" is run, the first combobox on the form gets focus.
The tab stops are off and there is no other code involved.
This causes no real problems other than the dropdown box appears before the form is opened and then closes when the legitimate ctl.setfocus is called.
If the form is bound before the load event, the same behaviour occurs when the form is bound to a different table.
How do I sop this.

 

[arnelgp]

which code do you set the recordsource?
maybe Disable (Enabled=False) the combobox before setting the recordsource and then Enable it after.

 

[John Sh]

which code do you set the recordsource?
maybe Disable (Enabled=False) the combobox before setting the recordsource and then Enable it after.

Thank you. That worked.
I set the recordsource in the onload event after getting the table name from args.