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
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