Transfer data from a form to a parameter query

[bakerratface]

Hello,
I currently have a query that I have to enter the same data several time in order to generate a report – each time the data that is entered is the same but used by the report in different ways e.g. to create a graph and display the data of text.

Is there a way that I can create a form that the user can enter the data into and then click a button which would transfer the data into the parameter query?

 

[twoplustwo]

In the criteria for the query:

[forms].[YourFormName].[YourFormField]

 

[boblarson]

In the criteria for the query:

[forms].[YourFormName].[YourFormField]

Close - you need the BANG character after forms:

[Forms]![YourFormName].[YourFormField]

or

[Forms]![YourFormName]![YourFormField]


The bang is considered late binding and the dot early binding. When accessing the forms collection you need to use the ! character since you can't really access it using early binding (in certain instances).