Passing Query field information

[TBOB]

I'm using one form to build an SQL string and then display those results on another form. That part is working fine. What I would like to do is to pass the selection criteria from that query to the new form to set certain properties. The original selection is based on one field only. How do I pass that variable to the new form?

Thanks,

Tony

 

[Aqif]

Hi,

How about saving the criteria value to a invisible text box and then opening the other form fetching criteria from that text box. It might not be ideal but always work for me.

Cheers!
ÙÇãá

It's important to learn the rules so that you know how to break them.

 

[PHV]

Or take a look at OpenArgs.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244