Forum Discussion

cfarri's avatar
cfarri
Copper Contributor
Aug 02, 2022

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...
access
Form field update
Query
  • arnel_gp's avatar
    arnel_gp
    Aug 03, 2022
    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_gp's avatar
arnel_gp
Steel Contributor
Aug 03, 2022
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.
  • cfarri's avatar
    cfarri
    Copper Contributor
    Aug 04, 2022
    That's great, DLookup() works perfectly - thank you so much!

Resources