Answer by
nk409 (33)
You can set the RecordSource property by using the form's properties window.At run time if you want to set use VBA programming. Code snippet
Dim fetchRecords As String
fetchRecords = "Write your query "
Me.RecordSource = fetchRecords
Here Me can be your form or dropdown or data binding controls.If we are using RecordSet, it will update record source at runtime
