Hello,
Im pretty new to all this so apologies if this is very simple..!
Basically, I have a form which simply has Username (in a combo box) Surname (in a text box) and First Name (in a text box). I used this code in the after update field of the combo box:
Private Sub Combo6_AfterUpdate()
Me.Surname = Combo6.Column(1)
Me.FirstName = Combo6.Column(2)
End Sub
so that everytime i selected a username from the drop down combo box list, the Surname and Firstname text boxes would populate automatically.
PROBLEM!!! - Now im trying to introduce a sub form to the form which will include Building, Room, Equipment Tag and Equipment Description. All these are sourced from a Query i made in which everything links correctly. Thing is i cant get this subform to update appropriately when the username is picked from the combo box in the main form. I know i could have these fields as text boxes in the same way as above but i really want it as a subform so I can easily update the tables.
Please please help, i'd be very grateful!!
Thanks,
Jim
Im pretty new to all this so apologies if this is very simple..!
Basically, I have a form which simply has Username (in a combo box) Surname (in a text box) and First Name (in a text box). I used this code in the after update field of the combo box:
Private Sub Combo6_AfterUpdate()
Me.Surname = Combo6.Column(1)
Me.FirstName = Combo6.Column(2)
End Sub
so that everytime i selected a username from the drop down combo box list, the Surname and Firstname text boxes would populate automatically.
PROBLEM!!! - Now im trying to introduce a sub form to the form which will include Building, Room, Equipment Tag and Equipment Description. All these are sourced from a Query i made in which everything links correctly. Thing is i cant get this subform to update appropriately when the username is picked from the combo box in the main form. I know i could have these fields as text boxes in the same way as above but i really want it as a subform so I can easily update the tables.
Please please help, i'd be very grateful!!
Thanks,
Jim
