Michael Dean
asked on
Not in list Process
When entering a new name into a Combo box with the Not in list set, I am noticing I can not enter a name with an Apostrophe. like O'Keef. It allows O"keef but not the apostophe.
I cannot reproduce your problem. Can you upload a sample database that exhibits this issue?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I attached the FE and BE databases. on the reviewer subpage is where the issue is. Reviewer combobox
DMC-Backup-Backup.accdb
DMC-Backup-Backup-be.accdb
DMC-Backup-Backup.accdb
DMC-Backup-Backup-be.accdb
...and the steps to reproduce this issue are...?
ASKER
In the Reviewers Combobox enter michael o'Riley, press tab or enter , it will prompt you to add a new item to the list click ok, then you will see the error.
<In the Reviewers Combobox >
The Reviewers Combobox where?
...on what form/table?
When the database opens, I am in the "Cases" (Open Cases) form, and there is a "TextBox" for the reviewer, not a combobox.
...and I cannot enter data into this texbox anyway.
The Reviewers Combobox where?
...on what form/table?
When the database opens, I am in the "Cases" (Open Cases) form, and there is a "TextBox" for the reviewer, not a combobox.
...and I cannot enter data into this texbox anyway.
ASKER
Sorry open up the Case Details Form and you will see the Reviewers Subpage.
Then change the code to:
strsql = "INSERT INTO Provider(Reviewer) " & "VALUES (" & "'" & Replace(NewData, "'", "''") & "'" & ")"
strsql = "INSERT INTO Provider(Reviewer) " & "VALUES (" & "'" & Replace(NewData, "'", "''") & "'" & ")"
seamus9909,
Where do we stand on this?
Where do we stand on this?