form field update
1 Topic
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 NationalGridReference to two numeric fields (X and Y). I want to have an X and a Y field in the form that automatically populate from NGR_to_XY. Whenever I join NGR_to_XY to the form's query it no longer allows editing of any fields in the form, although the X and Y fields are populated correctly. How can I join the NGR_to_XY query and still be able to enter data into the form? I did find this question but the solution uses VBA which I don't know how to use, is there a way that just uses regular design view?Solved1.2KViews0likes3Comments