Last week I had to change when a form would have its recordsource set, from On Open to On Activate. Is there a Best Practice for which event to set the recordsource on?
Last week I had to change when a form would have its recordsource set, from On Open to On Activate. Is there a Best Practice for which event to set the recordsource on?
I don't know about best, but most common is probably to set it in design view and leave it at that. Why would it need to be set dynamically, other than search results type of thing?
This does seem like the simplest solution.
I'm simple-minded, so simple solutions appeal to me.