Filtering records using textbox on form

Can I use the value of a bound textbox on an open form, as a criteria in a
query.
If so what would be the correct code for the SQL.
If not how can I hold the required value (number) that is selected by the
user from a
combo box at startup, so that I can use this value to filter records on
subsequently opened forms

Thanks
Ian

Ian Davies wrote:

 > Can I use the value of a bound textbox on an open form, as a criteria in a
 > query.
 > If so what would be the correct code for the SQL.
 > If not how can I hold the required value (number) that is selected by the
 > user from a
 > combo box at startup, so that I can use this value to filter records on
 > subsequently opened forms

<a style='text-decoration: underline;' href="http://juicystudio.com/tutorial/vb/database.asp" target="_blank">http://juicystudio.com/tutorial/vb/database.asp</a>

Near the bottom of the page are some examples
of building a query from textbox values.


HTH<!-- ~MESSAGE_AFTER~ -->