Software

Ask something
Question Locked

Using Access Forms to enter data to Oracle 11g

0 helpful
2 replies

by david

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

2 replies

by john.a.wills

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.

This discussion is closed to new replies.