I have a database in Access 97. Its a big telephone base, with numbers names and so on. I have done one search form with a List/Menu box and a search field. The List/Menu field contains of Mobilenumbers, Telephone. The problem is that i cant get the value in the List box to work. Look below

What am i doing wrong. I can harcode the Sql to Select * From Telef Where mobnr LIKE '%pmord%', but i want to have the List box working instead of that.

Henrik

Sorry the picture doesnt show up yet.....
Edited by - smalbenet on 25 Jan 2002 16:13:32<img src="draken.zafir.com/~smalbenet/img/searchform.jpg" border=0>

Edited by - smalbenet on 25 Jan 2002 16:22:57

Edited by - smalbenet on 25 Jan 2002 16:26:34

If you are trying to use a Boolean search I think this is what you want...

either

WHERE pmvalruta LIKE 'valruta' AND pmord LIKE 'sokord'

or

WHERE pmvalruta LIKE 'pmord' OR pmord LIKE 'sokord'

Wm. Kent Steelman

tnx,, its worked,, too tired to think.

/Henrik