I'm trying to use the Insert Record Behavior to update a table in MS Access. I want to use the form to directly update two of the fields (studentID, subject) in the table and then have the form update a third field (tutorRate) based on those first two form variables.

I have a record based on the following:

SELECT tutorRate
FROM rates
WHERE studentID = MMColParam AND subject = 'MMColParam2'

The form has the fields: studentID, subject, and tutorRate (based on the above record set)

The problem is that when the form updates the table, it does update all three fields BUT it always uses the default value I've placed in the recordset and NOT the value which should be generated by the two form variables.

Does anyone know what I'm doing wrong?

Hi Robert

Can you explain a bit more, if you do not want the values of this recordset inserted into the db then why do you have it?

Post back more code so we can see what's happening.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>