I'm trying to populate a textbox based on other controls on the same form using the AfterUdate event.
How do I populate from a combobox?
How do I populate from another textbox and string them together?
I tried the above but not working. Only gives me the "GP-".
The cboProjectFY is a combobox with the ID and the two digit year.
Need a hand.
Thanks
How do I populate from a combobox?
How do I populate from another textbox and string them together?
Code:
Private Sub PROJECT_NAME_AfterUpdate()
Dim Prefix1 As String
Prefix1 = "GP-"
Me![BergenNumber] = Prefix1 & Format([cboProjectFY].[Column](1), "00")
End Sub
I tried the above but not working. Only gives me the "GP-".
The cboProjectFY is a combobox with the ID and the two digit year.
Need a hand.
Thanks