themanof83
Registered User.
- Local time
- Today, 22:36
- Joined
- May 1, 2008
- Messages
- 73
Please can someone spot the errors of my ways, this is driving me nuts...
I am trying to see if a record already exists matching the criteria used in the DCount function. I have used this successfully in other areas of my project but it doesn't seem to like this one!!!
I am getting a Data Type mismatch in Criteria expression - error.
Folder Name (text) and Programme ID (number) are fields in table Folders. I am seeing whether a record exists in the table that matches the values entered on a form (Me.Main_Folder and Me.ProgID). As follows:
stLinkCriteria = "[Folder Name]=" & "'" & Me.Main_Folder & "' AND [Programme ID]='" & Me.ProgID & "'"
Dup = DCount("[Folder Name]", "Folders", stLinkCriteria)
I guarentee its something stupid I've done but I have no hair left....
Thanks in advance....!
I am trying to see if a record already exists matching the criteria used in the DCount function. I have used this successfully in other areas of my project but it doesn't seem to like this one!!!
I am getting a Data Type mismatch in Criteria expression - error.
Folder Name (text) and Programme ID (number) are fields in table Folders. I am seeing whether a record exists in the table that matches the values entered on a form (Me.Main_Folder and Me.ProgID). As follows:
stLinkCriteria = "[Folder Name]=" & "'" & Me.Main_Folder & "' AND [Programme ID]='" & Me.ProgID & "'"
Dup = DCount("[Folder Name]", "Folders", stLinkCriteria)
I guarentee its something stupid I've done but I have no hair left....
Thanks in advance....!