Update record based on Pass-Through Query

[SmallTime]

How would I go about updating a record on a form that's bound to a pass-through query? I want to avoid binding the form to a linked table.

To my understanding, pass through queries are read only, and so if I enable editing the forms data the fields remain locked and I hear the classic 'ding'. I'd be really interested in hearing how others go about this.

Regards
Small-Time

 

[SmallTime]

Just in case anyone interested.

I created a tmptable from the pt query (saves having to drag all records down from a linked table) and used that for the record source then passed params to a SPROC. It does the trick but what a palava. Hope the next version of Access does a better job of communicating with SQL-Server.

Regards
SmallTime