Hi All
I have set up a combo box on a form.In the records there are records commencing O'Sullivan but when I try to retrieve these records it gives errors.Is there any way round this problem.

Thanks
Brendan

__________________
Brendan Bartley

Depending what code you're running after you choose the name, you could be experiencing problems with the apostrophe in "O'Sullivan". What is the exact error and the code that produces it?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Error no 3077 Description:Syntax error (Missing operator)in Expression

And what is the actual code where this happens?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

   Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[OFFICE] = '" & Me![Combo8] & "'"
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark

Sounds like an apostrophe problem to me. Have a look at this discussion. It talks about first changing the ' to a double '' and THEN making the comparisons. It may be what you need.

http://p2p.wrox.com/topic.asp?TOPIC_ID=5655


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Brendan,
Try this:

rs.FindFirst "[OFFICE] = " & """" Me![Combo8] & """"

Kevin

dartcoach

Brendan,
Connell,John, "Beginning Visual Basic 6 Database Programming", by Wrox,page
259,Checking and Fixing Records with Apostrophes.
If after expert advises u are not out of troubles, text books may help, u
should check the title above if possible.
rgds Penta