Trying to bind a text box on a form to a field in a Query

[AshikHusein]

I have created a form and I need to incorporate two boxes for dates.

Effectively it is to show the end user that the reports being analyzed are for a certain period.

To do this I have made a query which is based on the underlying table to be analyzed and this table has a date field for every record being entered in the table. The query generates the min. of the date and the max. of the date.

ON the particular form under consideration, I am trying to get these two dates ( the min. and the max.). So what I do is that I make a text box and under the control source property of the text box I link the min. field of the query (for the minimum of the dates of the table) and I repeat the process for the max. field.

I thus presume that these boxes will get bound to the particular query fields.

But what happens that when I see the form in 'form view' is that instead of giving me the min and max dates I get "#Name?" in the boxes Could anyone tell me what am I doing wrong or is there a better way to go about it?? Thanks.

 

[AshikHusein]

I am using the following but it is still not working:

For the control on the form (which is a Text box called [Text16] I go into properties and select "Data". For the control source I type the following:

=Dmin([Date],[table name])

where Date is the field in the table. In form view it still shows #Name?. What am I doing wrong here or am I missing something completely??? Thanks and would appreciate a clarification.

 

[AshikHusein]

Sending the code

This is the code forthe Control Source in the Properties of the Text box.

=DMin([Date],[tbl_Call_Coding_Data_New1])

Thanks.

 

[AshikHusein]

Will try to get that changed

The original fields were defined and named by the management. But I will take your suggestion and see if it can be changed. Will get back to you if there still is a problem.

By the way I was just browsing through the Microsoft Knowledge Network for some different issue and I came across something which said that if you get a #name? errror you could be missing some systems file. I did not give it much thought since I was focussed on another problem but are you aware of such a thing?

Greatly appreciate you help in all matters and would like to thank you once more!!