Text Field SQL????

[GJT]

I have written a query that returns data from a number of tables and one table in particular is preventing the recordset from being updatable. This is a pre-requisite!

To get around this issue, I have decided to remove the problem table from the query and use text fields on my form to display the appropriate data depending upon an Id value returned from said query.

i.e. txt field control source = (SELECT OD FROM Tbl_A WHERE Id = 1) - Id is available from form query

Is this possible ? Initial trials I have carried out would suggest - no.

 

[Mile-O]

No need to go beyond Initial trials - the answer is no.

 

[GJT]

Any ideas on how I can present this data in an appropriate format on the form or any other way ? Messagebox perhaps but this is not really ideal as each individual record would need to be interrogated one at a time....????? Any ideas?

 

[GJT]

No problem people - have used DLookup - which does the job nicely!