Programmically Setting Referencing A Query As A RecordSource

P

PC User

I'm not very good at converting a query into VBA, so I'm looking for a
way to reference two update queries that select and deselect
checkboxes. I want to change the recordsource on a subform by using
command buttons on the parent form. I get an error on the recordsource
statement. Can someone help me?

Dim strSQL As String
Dim Frm As Form
Dim sfN As Form 'Program Notification SubForm
Set Frm = Forms!frmMainEntry.Form
Set sfN = Frm.[fctlNotifications].Form
strSQL = "qselNotificationSelectionYes"
sfN.RecordSource = strSQL
sfN.Requery

Thanks,
PC
 
A

Allen Browne

Try:
Me.[fctlNotifications].Form.RecordSource = "qselNotificationSelectionYes"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on Code - Create "Normal" Outlook Task from Access 3
multi select list box in a form as a query parameter 3
ListBox as criteria for query 6
Multiple Listbox selectin and query criteria 11
Form's new SQL recordsource returns nothing 5
Excel Export Filtered Form Data To Excel 0
Count Selected CheckBoxes On Continuous Subform 8
Update the subform or refresh based on multiple selection in a lis 1

Top