Query linked to textbox on form

[Moss100]

Hello I have a query which gets one of its parameters from a text box on the form.

The query looks for the value in textbox100 on the form (out of interest this lets the user type a surname into text100, click a button and the query runs fine.

To be clear, if the textbox contains Smith, then the query returns the values with Smith as expected.

I would like the user also to be able to type in <>"Smith".

When textbox100 contains <>"Smith" the query fails. This seems odd because typeing <>"Smith" directly into the query runs fine.

Is there a simple way around this?

I have tried the textbox100 values as <>"smith <>Smith "<>Smith" - all without success

Many thanks Mark

 

[Andrzejek]

Could you show us "the query" ?
And where your query expects "Smith".


Have fun.

---- Andy

 

[dhookom]

Your parameter can't contain the operators like "= <> >= <= LIKE BETWEEN ..." You need to find another solution which might involve code to update the SQL of the query.

Duane
Hook'D on Access
MS Access MVP

 

[Moss100]

This is the sql bit..

WHERE (((APPOINTMENTS.STARTDAT)=[forms]![Main_View]![Page1_date]) AND ((APPOINTMENTS.APPOINTMENT_FOR)=[forms]![Main_View]![textbox100]))

Thanks

 

[Moss100]

I feared there may be no easy solution - thanks anyway

 

[Moss100]

Any ideas for a way forward?

 

[dhookom]

I think I have an FAQ in the queries forum on how to use a little DAO code to change the SQL property of a saved query.

Duane
Hook'D on Access
MS Access MVP

 

[Moss100]

Thanks all - i found this on the web and it has solved my problem....


Like nz([Forms]![Main_view]![text100],"*")

Hope it will help others

 

[dhookom]

I'm not sure how that resolves your initial question regarding <>.

Duane
Hook'D on Access
MS Access MVP