D
Dave H.
I have a form that when you click on a field it opens
another form with the particular record based on the data
in that field. It works by running a macro that selects
the appropriate record by matching two fields. Form A
Field 1 = Form B Field 1 AND Form A Field 2 = Form B Field
2. This works like a charm. However, when one of the
fields has a text of more than about 100 characters the
form opens with #Name? in every field. The field in the
underlying table is set to 255 characters. Why am I
getting the #Name? error?
another form with the particular record based on the data
in that field. It works by running a macro that selects
the appropriate record by matching two fields. Form A
Field 1 = Form B Field 1 AND Form A Field 2 = Form B Field
2. This works like a charm. However, when one of the
fields has a text of more than about 100 characters the
form opens with #Name? in every field. The field in the
underlying table is set to 255 characters. Why am I
getting the #Name? error?