>I have a question about the parameters? Is there a buil-in parameter function that I could use to build parameter just by using controlSource of the textbox. Because when I create parameter I usually open up another form and store the parameter in a temperary database, and match the data in temp. database with my existing database using SQL command.
Samuel, look into Form Properties. Go to the FORM menu pad and check New Property. You can add as many new properties as you want, and store data in them which remains until the form is closed. Unlike temporary tables, you don't need to worry about file names and deleting them. I use them to store parameters passed to the INIT method when a form is opened, whether the form is in Add, Edit or Read Only mode, etc.
When you use a Form Property to store a view parameter, you just store the property to the view parameter name:
If your view is
SELECT * from mytable where myfield = ?cFieldVal.....into cursor MyView
then you would store the correct value in your new form property cViewParam.
cFieldVal = Myform.cViewParam
sele MyView
requery()
HTH
Barbara