Display Query field in textbox on form?

[Kevo]

Hi,



I have a form that alows the user to enter a startdate and enddate then a run query button. This displays a query that gives them the total records between the dates chosen.

Works great.....

Here is my question,

Instead of displaying the query in query form....can I have the query "run" in the background and the results show in a textbox on the form?

I have tried numerous things to no avail.

Is there a better way to do this....maybe another method besides using a query?


Thanks,
Kevin

[pbaldy]

If the query returns a single record:

=DLookup("FieldName", "QueryName")

[Kevo]

OK, Thank you. That works fine....but how do I get it to "run" the query but not "display" it.....

In other words, I just want the query to run and display the results in the textbox (it is doing this now thanks to you) but I don't want the query to come up.

[pbaldy]

Don't run the query. That function will run it in the background.

[Kevo]

In my messing around.....now my query does not work as expected.

I have

LoadID LoadDate

Count Group by

(Show) (Do Not SHow)

under LoadDate I have ..... >= Forms!frmQueryMenu.btnStartDate < Forms!frmQueryMenu.btnEndDate +1



It was working, but somehow I did something and now it is displaying the records separately (1),(3),(3) ..... instead of one total (7)

Any idea what happened?

[pbaldy]

I think you want Where on the date field rather than Group By.