ClaraBarton
Registered User.
- Local time
- Today, 02:18
- Joined
- Oct 14, 2019
- Messages
- 423
I have a button that pops up a form for exporting records.
The open event is:
From this I do a little cleanup and create a Sql statement.
My problem is this Sql returns a statement where the recordsource is the query that fills the form but the filter is the name of the form. I think this is where I'm getting a 3061 Too few parameters error.
How do I fix this?
The open event is:
Code:
txtSource = Screen.ActiveForm.RecordSource
If Screen.ActiveForm.FilterOn Then
txtFilter = Screen.ActiveForm.Filter
End If
From this I do a little cleanup and create a Sql statement.
My problem is this Sql returns a statement where the recordsource is the query that fills the form but the filter is the name of the form. I think this is where I'm getting a 3061 Too few parameters error.
Code:
SELECT [ContactName],[ContactsID],[Ck],[Company],[LastName],[FirstName] FROM (SELECT * FROM qryContacts ) WHERE ([frmList].[Ck] Not In (0))
How do I fix this?