Larry Brister
asked on
MS Access 2003 VBA Filter
My following COde works...
I'm getting some errors when I try and add an addional filter for timeSheetID
I can pass it in fine...but proper syntax for second =?
I'm getting some errors when I try and add an addional filter for timeSheetID
I can pass it in fine...but proper syntax for second =?
Public Sub loadData(htid)
'Load combobox with default data
loadCombo
'Apply data filter after resetting to false forst to clear any residual data
Me.FilterOn = False
Me.Filter = "hoursTrackingID = '" & htid & "'"
Me.FilterOn = True
'This is required for new record inserts
Me.txtHoursTrackingID.DefaultValue = htid
End Sub
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER