hi all,

having a bit of trouble with a function

MsgBox DepositIntoInventory(ManageInventory.DepositLot,
ManageInventory.DepositCases, ManageInventory.DepositMonth), vbOKOnly, "Alert"

is the call and i'm getting a type mismatch error

Public Function DepositIntoInventory(lotNum As ComboBox, numCases As
TextBox, monthName As ComboBox) As String

DepositIntoInventory = "Deposit of " & numCases.Caption & " cases of lot
" & lotNum.Value & " in " & monthName.Value & " was successful."

End Function

all the types are correct, DepositLot is a combobox, DepositCases is a
TextBox, DepositMonth is a ComboBox

if i change the types to string in the definition of the function, and
remove the qualifiers - then it works ok.

can anyone help explain why?

tia

J