Syntax problem? Strings

[axess_nab]

Hey guys axe again I'm still trying to figure out the joining strings thing but right now I'm trying to open a supplier record in a form by double clicking its name. I'm using a macro openform and I try to use the Where condition to determine in which record I want to open the form but it simply doesn't work well it does but it doesnt open the record I'm clicking. This is the condition y work with

="Supplier ='" & "Supplier1" & "'"

Supplier is the field on the form I want to open and Supplier1 is the field in the form I'm working with.

When working with numerical values it's easier I use this condition

="[Id]=" & [Id]

This works as a charm but I need to work with strings and I'll be using alphanumeric Id's in other parts of the data base so I'll rather learn whats the correct syntax



I hope someone can help thank you!

[khalid]

Hi,
you are using " double quoted around the Fieldname which is wrong, use it as you use for numeric field

="Supplier ='" & [Supplier1] & "'"

For String data type, there should be single quotes & "'" before and after the text data type field.
Hope this help.

[axess_nab]

khalid will you be kind enough to clarify? I really don't understand. Do you mean I should put it like this:

="Supplier ="" & [Supplier1] & "" or ="Supplier =' " " & [Supplier1] & " ' "

[khalid]

khalid will you be kind enough to clarify? I really don't understand. Do you mean I should put it like this:

="Supplier ="" & [Supplier1] & "" or ="Supplier =' " " & [Supplier1] & " ' "

No, it should be like this:

For string data type:

="Supplier ='" & [Supplier1] & "'" 

For Numeric data type:

="[Id]=" & [Id] 

Remember that when you use string data type (text field) it should be enclosed in single quotes ' on both sides of the field, like '" & [Supplier1] & "'" and for numeric it should not be used, if you use it vise versa it will produce an error.

Hope this clear.

[axess_nab]

khalid thank you very much. Till now I could try your solution and it worked like a charm I really appreciate the time you took to read my problem and give me the proper solution! I hope one day I can do the same for another newbie. Now I need to continue to work on my db Thanks again!

[khalid]

khalid thank you very much. Till now I could try your solution and it worked like a charm...

You are welcome axess..

Glad that it solved the problem, yeah why not you will be able to solve the other's problems one day. Everyone can learn and achieve his goals with continuous struggles and hard work.

Good Luck!