Forum Discussion
Solved
Linking an external query to a field in a form
I have a form where the record source is a query joining several tables. There is a field for location (NationalGridReference). I have an external query (NGR_to_XY) which converts NationalGridReferen...
- suggest to not Join query NGR_to_XY to your original query in your form.
use DLookup() to retrieve the values from this query, therefore making your form updateable.
Arnel's right. Don't even TRY to create editable queries from multiple underlying tables or queries unless you have very advanced SQL skills. The chances of such queries becoming non-editable grow quickly as more complexity is introduced.