Date Range on Form

[normie]

I have a form for a query...to use the date range a pop up box comes from the query...Is there a way I can enter the START and END dates in boxes on the form instead of the query entries?



This form will be on a inside shered drive and this will make it easier for people looking for the data

[June7]

Yes, that is much better approach because can validate user entry.

Query input parameter reference to textboxes named tbxStart and tbxEnd would be like:
Forms!formname!tbxStart
Forms!formname!tbxEnd

The form will be where?

[normie]

I have a form for a query...to use the date range a pop up box comes from the query...Is there a way I can enter the START and END dates in boxes on the form instead of the query entries?

This form will be on a inside shered drive and this will make it easier for people looking for the data

Does this need to be a seperate form or can I add it to the exsisting form? as well do I need to put parameters on the source qurey?

The form is on a shared drive that is inhouse for people to view this form and able to put in the date

[June7]

Same form or another form - the form RecordSource would be the query with the parameters. I don't know what the RecordSource of the existing form is. If it is a query that includes the date fields, then add the parameters.

[normie]

I have entered this in the control source =[Date]![tbxSTARTDATE] and I get an #Error message
The name of the query for the form is DASHBORD DATA

[June7]

Why would you enter [Date]![tbxSTARTDATE] in control source? Control Source of what?

I suggested you put reference to form controls in the criteria row of a query. That is where input parameters for query go.

[normie]

Not sure what I am doing wrong....the "between" criteria is on a query that is one of the 3 queries on the form query...where do I enter "Forms!formname!tbxStart
Forms!formname!tbxEnd" and do I add text boxes to the form?....I want to be able to open the form and enter the date range there and not in the pop up boxes

[June7]

How does a form have 3 queries? Do you mean the form RecordSource is a join of 3 queries?

Yes, must have textboxes on form in order to refer to them. These would be unbound textboxes for user to input date criteria.

Put reference to form textboxes in place of the parameter prompts in the query.

Show your complete query statement for analysis.

Do you want to provide project for analysis?

[normie]

Please see attachment
This has become a mission now

[June7]

Try this criteria - no quote marks:

BETWEEN Forms!Dash!tbxStart AND Forms!Dash!tbxEnd

[normie]

I have followed all the above instructions and the text box will come up for the query and will select the data and I am able to enter the dates in txbStart and txbEnd boxes on the form but the result is blank in the form boxes

[June7]

You have form that has the query as RecordSource?

The query refers to the unbound textboxes as parameters?

One more step. After entering the date values into the textboxes the form must be requeried. You can click the Refresh button on the ribbon or run code.

If you want a visual tutorial on building a filter onto a form, review this: http://datapigtechnologies.com/flash...tomfilter.html

What do you mean by 'text box will come up for the query'? Nothing should 'pop up'.

[normie]

Query 1 has the data including the input dateand the txbStart and txbEnd parameters... Query2 uses query 1 except for the input date and sums the other values... the form is built on Query 2
The unbound textboxes that the parameter query points at are on the form
Hope this is clear

[June7]

I've never done that but it should work. Still need to Requery form after dates entered in boxes. Make sure the spellings of the boxes are correct. You have shown both txb and tbx.

At this point, I probably can't help anymore unless you want to provide the project.

[normie]

Thanks for your help...I cant figure it out I run Query2 with the textboxes and get the results but the form for the same Query comes up blank after using the form boxes..I must be mising a step somewhere