Using Access Forms to enter data to Oracle 11g

By David ·
I'm using Access 2003 forms with several subforms to enter data into Oracle 11g. In my forms I have combo boxes, I select the equipment to add a record. The first record enters into the Oracle tables fine. However, when entering a subsequent record for the same equipment, the data in the main form is correct, but in the subforms a record is added but it's a duplicate of the first record. This occurs in the subforms. Please help.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Oracle 11g...

by john.a.wills In reply to Using Access Forms to ent ...

may have its faults but the problem here surely lies with your Access forms. I have not had this problem, but perhaps I have not had your combination of data structures. A good question to ask yourself is why you have subforms when you appear to be writing to one table only.

Related Discussions

Related Forums