Just a quickie...

[Nightowl4933]

I have a fairly complex form used to display quite a lot of information, and the data source for this is a table.

I also have a query that calculates dates for each record within that table (a calculated 'end' date) and which I would like to use in the same form.

Should I use the table or the query as a data source for the form, or can I use both? If the latter, how is this achievable, because all I get is a #Name? error when I add a text box and use the query as the data source for it.

Thanks

 

[Minty]

It depend on the complexity of the query - You can link the query back to the table in another query , or add the calculation to a new query based on your table. Provided the end result is an editable recordset either approach will work.

 

[arnelgp]

you can't use your query since it is not updatable because of calculated field in there.

 

[Nightowl4933]

Ah, silly me! I'd kept the query in the database, but I'd already done the calculation in a text field on the form - so the query isn't needed!

Thank you