[AccessD] code problem

I'm guessing you just want to enclose the NewData string in single quotes.
Try this.

    strMsg = "'" & NewData & "' is not in the list. "



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Joe Hecht
Sent: Saturday, November 27, 2004 10:41 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] code problem


I am copying and will attribute the following code from KG et al ADH



Private Sub cboEmpName_NotInList(newdata As String, Response As Integer)

Dim strMsg As String

Dim rst As Recordset

Dim db As Database





    strMsg = "'"& NewData &"'" is not in the list. "

    strMsg = strMsg & "Would you like to add them?"



Does any one know why the first strMsg line is evaluating to to red ?



Thanks



JOE HECHT

LOS ANGELES CA

jmhla at earthlink.net



--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com