Two tables in a form

[simplydk]

Having a form with 255 fields connected with Table A. Now I wanted to add more fields into the same form from Table B. How should I go about doing this without using subform?
(Not using subform because I want to have only one set of Tab Index)

[ryand09]

You must relate the table and use a quey as your data source

[loringdo]

I probadly would have broken the table into more of a one to many type etc. Use drop down list having all the tables fields. Then us ADO in back ground to update your fields. That way your form, for me anyway would not be so clutter. Pick what field you want updated. Allow the code in back ground to do all your work. Slow on data entry but, another way.

doug