data type mismatch

  • Thread starter Thread starter johnlute
  • Start date Start date
J

johnlute

[numProfilesRevisionsID] is an autonumber field (long integer) with no
format.

The following returns a data type mismatch error:

strWhere = "[numProfilesRevisionsID] = """ & _
Forms![frmRevisions].Form![numProfilesRevisionsID] & """"
DoCmd.OpenReport Me!cbSelectReport, acPreview _
, , strWhere

Does anyone see what the problem is? I suspect I'm improperly
referencing the autonumber...?

Thanks!!!
 
On Thu, 23 Jul 2009 06:45:21 -0700 (PDT), johnlute

You are. Take out the extra double-quotes. That's only appropriate for
text fields.

-Tom.
Microsoft Access MVP
 
Thanks, Tom. That was it.

On Thu, 23 Jul 2009 06:45:21 -0700 (PDT), johnlute


You are. Take out the extra double-quotes. That's only appropriate for
text fields.

-Tom.
Microsoft Access MVP


[numProfilesRevisionsID] is an autonumber field (long integer) with no
format.
Click to expand...
The following returns a data type mismatch error:
Click to expand...
strWhere = "[numProfilesRevisionsID] = """ & _
Forms![frmRevisions].Form![numProfilesRevisionsID] & """"
DoCmd.OpenReport Me!cbSelectReport, acPreview _
, , strWhere
Click to expand...
Does anyone see what the problem is? I suspect I'm improperly
referencing the autonumber...?
Click to expand...
Thanks!!!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
Thanks! For the record I just changed to this:
strWhere = "[numProfilesRevisionsID] = " & _
Forms![frmRevisions].Form![numProfilesRevisionsID] & ""

If it's a number then you don't need the brackets. Try this:
 strWhere = "[numProfilesRevisionsID] = " &
Forms![frmRevisions].Form![numProfilesRevisionsID]

--
<a
href="http://www.software-matters.co.uk/bespoke-database-design.html">Bespoke
Access Database Development</a>
<p>Software Matters</br>
Straightforward solutions that work</p>



johnlute said:
[numProfilesRevisionsID] is an autonumber field (long integer) with no
format.
Click to expand...
The following returns a data type mismatch error:
Click to expand...
strWhere = "[numProfilesRevisionsID] = """ & _
Forms![frmRevisions].Form![numProfilesRevisionsID] & """"
DoCmd.OpenReport Me!cbSelectReport, acPreview _
, , strWhere
Click to expand...
Does anyone see what the problem is? I suspect I'm improperly
referencing the autonumber...?
Click to expand...
Thanks!!!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top