Hey everyone,
So I have a query criteria:
Like [Forms]![People]![Textbox].text
but this query runs in a different form than this textbox.
I also want to change this variable on the query depending on the form im using.
My understanding is that i can use a VBA Function in my query.
SO,,,, My idea is something like this (bear with the fact that im VERY new to vba coding, im trying to learn them :S
Code:
(In top of module)
Dim txtbx as string
Private sub on_click
txtbx = me.textbox.text
end sub
in next form (the one with the query)
public function frmtxtbox()
frmtxtbox = txtbx
end sub
Then in my query criteria i can write... Like frmtxtbox() & "*"
Am i on the right track??