Correct syntax for an integer value

[nflutter]

I'm trying to pass a string to print the current record on an access form, keep getting a syntax error, just cant work it out.

Dim strWhere As String
strWhere = "Contact ID=" & Me.ContactID

I think there should be single quotes around the Me.ContactID value but cant get them right! any help appreciated.

Thanks

 

[dhookom]

If Contact ID is a field name with a space in it (never a good practice and the field is text, try:

Dim strWhere As String
strWhere = "[Contact ID]=""" & Me.ContactID & """"

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]