Hello
Using Access XP with MX/ASP. I'm trying to Insert a record into one table, redirect to a page that has a command to update another table's record (passing via session variable). I'm a beginner on passing the variable but 100% lost when it comes to Command Object authoring. I DO NOT know how to reference SET or WHERE in the SQL window... ANY help or tutorial reference would be greatly appreciated.

for the SQL part I can help out alittle, let me know if XP won't like this syntax

UPDATE mytable
SET (field1, field2, etc)
Values (var1, var2, etc)
WHERE field = condition

INSERT INTO mytable (field1, field2, etc) values (var1, var2, etc)

you can also use update like so:

update mytable set myfield = variable

There are quite a few tutorials and faq's concerning SQL, even on this website...

HTH.

with regards,

Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5