Fetching data from multiple tables.

[bupinder]

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.

[ranman256]

if it is related data, you should be able to join all 3 tables in a query and get all the data at once.

[June7]

Type mismatch means you are trying to link tables on fields that are not the same data type. We would need to know more about data structure to advise.

If you need to print data, best to use a report.

[bupinder]

thanks.. i just solved the issue by using text boxes, dependent on comboboxes based on a single table.