i am using a form where text boxes from 3 different tables will be used to fetch pre-recorded data. it will be used as an auto-generation form to print out a letter where different fields will use values from the tables.
The trick here is that a the first form contains the primary key which links to this form, on clicking the 'field' this form will open with data being fetched from the tables which has already been filled by other forms.
now the problem is, 'type mismatch' error. The form works fine upto 2 tables, but when i put in the fields from 3rd table, errors come.
any way of solving this will be very helpful.
PS: i used sub-form, but still i need fields from 3 tables at different places.