Hi Everyone...it's slowly coming along; however, I'm still having the same problems of the subforms (have 3 now) NOT clearing when I navigate to a new record on the MAIN form (frm_Freelancer_Information). I added the following code on the sfrm_Freelancer's_Languages subform to see if it would work (didn't bother adding anything for the other 2 subforms since it didn't work for this one):
Private Sub Form_Current()
Me.lsb_Languages.Requery
End Sub
I also can't figure out how to retain the multiple selections for the saved records once I exit the form and then return to it. Since the listboxes are each based on queries and the selections are sent to junction tables, I don't know how to get the results from the junction tables to show back up on the form when we attempt to review the freelancer's record.
Like I stated in my previous post, it's doing what I want it to do...retaining & clearing the listboxes; however, it's doing so at the exact opposite time I need for it to do each one.
I've attached an updated copy of the database. I hope one of you can figure this out.
Thanks,
USEN
P.S. Thanks to you all, my Employer was very pleased with my progress when we met on Monday morning.
Private Sub Form_Current()
Me.lsb_Languages.Requery
End Sub
I also can't figure out how to retain the multiple selections for the saved records once I exit the form and then return to it. Since the listboxes are each based on queries and the selections are sent to junction tables, I don't know how to get the results from the junction tables to show back up on the form when we attempt to review the freelancer's record.
Like I stated in my previous post, it's doing what I want it to do...retaining & clearing the listboxes; however, it's doing so at the exact opposite time I need for it to do each one.
I've attached an updated copy of the database. I hope one of you can figure this out.
Thanks,
USEN
P.S. Thanks to you all, my Employer was very pleased with my progress when we met on Monday morning.