Update Current Record

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

Guest

I have 2 tables, tblEmployee & tblSlips, tblEmployee has 2 fields EmployeeId
& EmployeeName, tblSlips has 5 fields, SlipId, EmployeeId, LeaveDate,
LeaveType, & LeaveHrs. I have a one to many relationship using employeeId as
the PK in tblEmployee & the FK in tblSlips. The problem is when I created a
form and made the employeeName a comboBox. When I change from one employee
name to the next the records in the subform don't change. I used the Wizard,
could someone tell me what I'm mis-understanding??

Thanks You
 
When I change from one employee name to the next the records in the subform
don't change.
How are you changing? Are you select the new name in the combobox. If so
then check your tblEmployee data directly in the table and see if you changed
the name.
 
Only you could answer
could someone tell me what I'm mis-understanding??
Click to expand...

You haven't fully described what you did to get to your present
situation.

Make a copy of the form in question so that you can always get back to
where you are.

One quick thing to try is to open the form in design view, select the
subform control and delete it. Reduce the form size so that it takes
up only part of the screen. Find the same (sub) form in the database
window and click and drag it into the space where you just deleted the
subform control and drop it. Maximize the main form and adjust the
subform control on the main form the way you want it.

With the subform control selected, turn on the Properties window and
see that the Link Master Field and Link Child Field have the same
value (or names that you have changed and that you know should hold
the same value). If they do, your form and subform should play
together. If they don't then you'll have to do some digging and post
back with complete details.

The clue that you might have been following a wrong path is that you
wrote that you "used the Wizard". I don't know your version of Access
so don't know just how appropriate that statement might be in the
modern world. I've been using subforms a long time. There used to be
petty good Help on subforms that would walk you through the steps.

HTH
 
Back
Top