Record selection based on a conditional

[jimleon]

Hello All

I am trying to select a record to edit using the following commands

query = "select * from companies where name=" & Forms![Main Details]![CO_NAME]

Set record = dbbooking.OpenRecordset(query)

Forms![Main Details]![CO_NAME] is pointing to 'dummy co'

but i get this error when attempting to select the record

Syntax error (missing operator) in query expression 'name=dummy co'

I have tried putting companies and name in square brackets but it doesn't affect it!

Any clues out there?

Many thanks in advance

[abouddan]

Hello All

I am trying to select a record to edit using the following commands

query = "select * from companies where name=" & Forms![Main Details]![CO_NAME]

Set record = dbbooking.OpenRecordset(query)

Forms![Main Details]![CO_NAME] is pointing to 'dummy co'

but i get this error when attempting to select the record

Syntax error (missing operator) in query expression 'name=dummy co'

I have tried putting companies and name in square brackets but it doesn't affect it!

Any clues out there?

Many thanks in advance

First I think we should know the format of the field "Name" in the table "companies". If it's a text so your query should be :

query= "select * from companies where name='" & Forms![Main Details]![CO_NAME] & "'"

You just have to add a single quote after (name=) and another one in the end of the query. so it's : Double quote, single quote, double quote (" ' ") without any space.

[jimleon]

Cheers, that worked a treat!

First I think we should know the format of the field "Name" in the table "companies". If it's a text so your query should be :

query= "select * from companies where name='" & Forms![Main Details]![CO_NAME] & "'"

You just have to add a single quote after (name=) and another one in the end of the query. so it's : Double quote, single quote, double quote (" ' ") without any space.