Updateable Forms and Multiple Table Joins

[Guest_imported]

I am currently involved in a project to convert an Access97 system to a Access2000 ADP Project with a SQL backend.

Here is my question:

What is the best way to create updatable forms when you have a recordsource that represents a 4 to 5 (or more) table join.
in other words ....

What is the preferred method of creating unbound updatable forms?

I have tried unbound controls with ADO Recordset and Command objects and nothing seems to have the feel and functionality of the bound forms that my users are comfortable with.

I would appreciate anyone who can shed some light on this subject.

I realize that this is a very general question so I am not expecting a specific example, just some ideas on how some of you may have solved this problem in the past.

Thanks jzcomputer