Form, query problems... (1 Viewer)

[DT]

If I put this in the criteria field (minus the quotes) "<>8" the query works find. If I try to capture the same info coming from a form with this in the criteria field (minus the quotes) "[Forms]![formname]![textfield]" it doesn't work. Any suggestions?

Thanks in advance.

DT

 

[MSAccessRookie]

I am not sure I have enough information to make a comment. How about showing the SQL for the query that you want to modify?

 

[pbaldy]

Wouldn't you want:

<>[Forms]![formname]![textfield]

 

[DT]

Wouldn't you want:

<>[Forms]![formname]![textfield]

pbaldy,

You are correct, that works. But how come I can't grab the <> from the form? If I place them directly in the query it works. I would like to have the query grab them from the form.

DT

 

[pbaldy]

If you're trying to build some sort of flexible search tool, you'll have to build the SQL dynamically in code based on the user's selections.

 

[DT]

If you're trying to build some sort of flexible search tool, you'll have to build the SQL dynamically in code based on the user's selections.

ok...that's beyond me, but I'll look into it...Thanks

 

[pbaldy]

There's a tutorial here along with a sample db that I don't think is exactly what you want, but it should get you on the right track:

http://www.mdbmakers.com/forums/showthread.php?t=4895