Display Query field in form?

[Ray67]

Hi,



I have a form that allows the user to enter a start date and end date then a run query button. This displays a query that gives them the total records between the dates chosen. Instead of displaying the query in query form I would like it to display it in a form. The query will return multiple records.



Thank you,

[June7]

Set the form's RecordSource property to the query. Check this tutorial:

http://datapigtechnologies.com/flash...tomfilter.html

[Ray67]

How can i do this but to display multiple records at the same time???

[June7]

Set the form to Continuous View.

[Ray67]

Thank you for your help it worked great. Just have one more questions. I'm using one combo box and it works great, but i would like to add two more combo box. The other two combo box would be for dates. How can i do this???

[June7]

The dates have to come from somewhere. The combobox RowSource would be generated same as for any other data. You have a table with date field that can be the source for date values?

[Ray67]

Yes i have a table with date field. I would like to use a text box. So user's can enter date.

[June7]

So you don't want combobox for date values?

On reflection, I have ever used a combobox for data entry of dates but certainly can. I have used a listbox to restrict date selection to dates in table for filter criteria.

I use textbox and input mask for dates: 99/99/"20"00;0;

A textbox won't restrict users to only dates in the table.

[Ray67]

For the date i don't want to use combo box. I would like for the user to be able to enter the date.

[June7]

So did my suggestion work for you?

[Ray67]

i try using the text box but it doesn't return any data now. What i'm i missing???

[Ray67]

With the combo box i would use row source. With text box there is the row source.

[Ray67]

The reason i don't want to use a list box is because all of my provider would end up with the same date. So in the list box it shows multiple of the same date.

[June7]

You mean 'With text box there is NOT the row source.' ?

You are using the date as criteria for a parameterized query? I seldom use queries like that.

Issue might be if no date criteria is entered. The query is still going to try to search for a date value. I don't think Like and wildcard works with date criteria. Give an alternate date value that is far enough in past or future that all records will be captured. Something like:

BETWEEN Nz([start date criteria], #1/1/1900#) AND Nz([end date criteria], #12/31/2900#)

Another issue might be if you are searching for exact date and the field has time part.

Need to know more about your data and the query.

Show the SQL statement. Show sample of date values from table. Or provide project for analysis. Follow instructions at bottom of my post. Identify the objects involved in issue.

[Ray67]

my user's would never look for exact date. The user would enter first date of the month and the last date of the month. So i would like to show all of the data for the month.