G
gtslabs
I have 2 tables joined to make a Many to Many 3rd table. I want my
3rd table to use some of the fields from the first table as default
values so they can be overwritten if needed. I copied the fields from
the first table to the 3rd so I have the same field type but the first
table has the suffix "default" in the field name.
I am in a form trying to use this formula to fill in my 3rd table
field (as a default value) based on a combobox:
=DLookUp([OMCdefault],[tbl-TestCodes]," [TestCode] = '" & [cbo_Tests]
& "'")
It is not working. The values returned are strings.
The field returns nothing and the newrecord line in the record
selector says #Name?
3rd table to use some of the fields from the first table as default
values so they can be overwritten if needed. I copied the fields from
the first table to the 3rd so I have the same field type but the first
table has the suffix "default" in the field name.
I am in a form trying to use this formula to fill in my 3rd table
field (as a default value) based on a combobox:
=DLookUp([OMCdefault],[tbl-TestCodes]," [TestCode] = '" & [cbo_Tests]
& "'")
It is not working. The values returned are strings.
The field returns nothing and the newrecord line in the record
selector says #Name?