Any Solutions? Access --> Oracle

Hello out there,

Here is what I am doing in a nutshell, making an M$Access 97 frontend and Oracle 8 backend through ODBC (7.2???) on M$Windows95/NT. I have created several subforms in M$Access and reference them through something like this : [forms]![RentedForm]![MovieID] to be the starting point for the subform query. What I want to do is INSERT INTO rental_transactions VALUES(rental_seq.nextval,[forms]!etc....); Is there any way to do this?

Basically what I want to do (if it is not very clear) is pass Oracle the value in a form object(box) to write to a column in my transaction file.

Anybody have any ideas and or working solutions? TIA--Mak Received on Wed Nov 19 1997 - 00:00:00 CST