Pass the value of a combo box to a calling function
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Pass the value of a combo box to a calling function
Hello all,
How to pass the value of a combo box to a calling function on VBA code Window.
my combo box is on Main form and has two fields HosID, HosName. The combo box shows the list of hosName.
I have a calling function.
Call AuditChanges( )
I have to capture the current Record ID which is embed in combo box and pass it to above function.
What should be placed inside of parenthesis?
Regards,
tibb
-
- Administrator
- Posts: 78589
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Pass the value of a combo box to a calling function
For example
Call AuditChanges(Me.Combo1)
if Combo1 is the namer of the combo box.
Call AuditChanges(Me.Combo1)
if Combo1 is the namer of the combo box.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03