Tabbing through a form

[Naia]

I have created a form with fields from two tables (A and B). However, when trying to fill out the form, I can only type in the fields from one form at a time. By wildly clicking around I can switch from the fields from table A to B. But the A fields delete.

Any ideas?

On a side note, I have found the entire process of trying to create a single form that will save to two different tables very frustrating. The Microsoft help files state you can perform such an operation, but give little or no direction. Can anyone recommend a resource for performing this sort of operation?

Thanks,
N

 

[boblarson]

To do one form with two tables, you can create a form for each and put them both on a tabbed control on a separate form as subforms, but if they aren't related to each other, don't select links to link them.

 

[Naia]

The tables are related.

I do not want to use subforms. I know there is a way to do it without them, I have been working with a database that is full of them.

 

[boblarson]

Not sure why you don't want to use subforms as they are really easy to use, once you get the syntax down, but you can use unbound forms and use DAO or ADO to do all of the work - the problem with that is that YOU have to do all of the coding.

 

[mixup]

What about creating a query with the tables and creating a form from that query?