Editable fields with multiple queries

[murgatroyd]

I have a form in Access 2010 where the data source is a single query (Query1). The form includes a field (Table1_Field1) that the user can edit (field properties has Enabled = Y, Locked = N, and form properties has Allow Edits = Y), and this works OK.

To enable some conditional formatting on a couple of other fields in the form, I need to get a couple of additional fields from other places. To do this, I have made two changes: (a) I added a second query (Query2) in Query1, with an outer join to one of the tables (Table1) there (because not every record in Table1 has a matching record in Query2), and (b) I made a third query (Query3) containing Query 2 and an additional table (Table2), which has no join (it contains only a single record with a couple of fields that I need for the conditional formatting in the form).

In the form, I now have all the fields I need, and the conditional formatting works OK, but Table1_Field1 is no longer editable (unless I remove both the added Query2 from Query1 and the added Table2 from Query2). How can I get the additional fields I need from Query2 and Table2 into the form without losing the editability of Table1_Field1 there?

(See diagram: View attachment 62476)

 

[arnelgp]

it is not possible to make it editable because of additional unrelated query/table you put in there.

can you not use Dlookup for your conditional format or create a function that will do the conditional format?

 

[murgatroyd]

Thanks for your reply. I haven't used DLookUp before, but I tried this and it worked fine.