sending vb to a QUERY

[habbabub]

how can i send text from a text feild from one form to another form using that text as the criteria to run the query?

 

[Mile-O]

I think you are going to have to elaborate on your actual problem here. Such generic questions can, like this one, appear unclear as to the intention.

 

[habbabub]

i have a string in vb from one form, and i like to pass that to another form

so that ID="123"
in form 1
is that same in form 2 (ID=123)

and then how can i use that to do an sql query to search for ID?
and spit all hte data into text feilds?

thanks!

 

[Dennisk]

If both forms are open then you can reference any control using the following notation

myControl=Forms!formsName!ControlName

If only the receiving form is open then the source form would have to store data. A global variable springs to mind or a column in a table.

 

[durexlw]

Also, look at this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=144978

 

[tehNellie]

You can also pass parameters/data between forms using openargs but if both forms are open then Dennisk's suggestion is probably easier to understand.