2 for the price of 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Guys and Gals,

I keep getting two records saved in my main table when only one record
should be saved.

Here's the controls on the form:
(a) Combo1 row source = EmpID
(b) Combo2 row source = DeptID
(c) ListBox row source = CourseID

Here are my steps:
1. I select an employee name from Combo1
2. I select a department from Combo2
3. I select a record in ListBox
4. I click the Add button to save data in a new record
5. I close the form

Now, when I open table Main I see this:

MainID EmpID DeptID CourseID DocNumber
1 2 4
2 2 4 A-AA-001

It looks to me that Access saves a record on it's own before I get the
chance to do it myself. I noticed that if I just fill the Combo's and close
the form without using the List Box, the Combo data gets saved anyway.

Is there anyway to control when data gets saved in Access?

-Simon
 
Back
Top