Searching Forms Problem

[Swillsy]

Hi Guys,

Recently I changed my form so that the dlookup expressions I had to look up values in another table were put into vba. This speeded everything up however now when I search for something it isnt searching for the values.

For example before I had a code box and a name box and the namebox had a lookup expression in it. When I searched for a name it found that record.

Now i have a code box and a text box which looksup the value in vb, but i cannot search by name only by number.

Is their away round this??

Thanks in advance

 

[pbaldy]

How are you trying to search by name? You shouldn't have any trouble doing so, other than text values must generally be surrounded by single quotes, while numeric values do not.

 

[Swillsy]

I am sorry pbaldy
I opened the database today and the search was worknig as normal - I must have missed an option in the search screen as it only working for ID numbers.

My bad