Hi, I have an ACCESS db , consists of one form , query and table. I first filtered the query using parameters(@value) , so when a user opens the form they immediately enter the prompt-values . However , I want to substitute the parameters with values from textboxes so I did this. In query design , i set the criteria to [Forms]![FormName]![TextBox]. However , when I open form , it returns nothing although the textbox has a value. When I execute the query(Datasheet view) , it prompts for parameter name [Forms]![FormName]![TextBox] , why does it not get value from Form's textbox? -Thanks
A:
1 Problem was with the criteria , it should be [Forms]![FormName].[TextBox] ( with a dot) and the next problem might've been that the form must be open at first.
DanSmith
2009-12-26 10:11:42
That isn't correct. The ! and the . are equivalent as far as the Access expression service is concerned for controls on forms.
David-W-Fenton
2009-12-26 21:16:04
If you want the value of the textbox on a form, the form must be open.
Jeff O
2009-12-30 21:16:28