Updatable SPROC on sub form

[scott]

I have a subform that has a sproc as it's record source. To display the
needed fields, I have to use a SELECT statement within my subform sproc that
includes an inner join. Is it possible to update a sproc on a sub form that
contains joins?

To test it, I got rid of the join within the subform's sproc and had a
simple SELECT from a single table and it seemed to work.

I was wondering if sql/access has a limitation on updating sprocs that
contain table joins?

Any help or ideas would be appreciated.