List box carry to subform

R

Ripper

I solved my listbox problem, thanks to Klatuu for the help. I know it was
simple, but it is Monday morning.

I have a listbox1 that filters listbox2. When I click listbox2 a subform is
populated via Master/Child link to carry the studentId to the subform1. No
problem there.

BUT

When I use the code in listbox2's afterUpdate:
Me.SubFormName.SetFocus
DoCmd.GoToRecord , , acNewRec

to go to a NewRecord, the ID number goes away. How do I have a new record
in the subform and carry the student number to the subform so the user does
not have to type it in?
 
Top