declaration

[Zlatko Matiæ]

I would like to pass full name (path) of a list box (ListBoxName) to a
function, so that I can reference it inside the function as
ListBoxFullName.Column(0, varItem).
How should I declare ListBoxFullName ? As object, name, string or something
else?

Zlatko

[Allen Browne]

Pass the list box instead of it's name.
You can then get at any of its properties or methods.

Example:
Function DoSomething(lst As Listbox)
Debug.Print "The list box is called " & lst.Name
End Function

Then call it like this:
Call DoSomething(Me.[NameOfYourListBoxHere])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Zlatko Matif" <zl***********@sb.t-com.hr> wrote in message
news:dq**********@ss405.t-com.hr...

I would like to pass full name (path) of a list box (ListBoxName) to a
function, so that I can reference it inside the function as
ListBoxFullName.Column(0, varItem).
How should I declare ListBoxFullName ? As object, name, string or
something else?

[(PeteCresswell)]

Per Allen Browne:

Then call it like this:
Call DoSomething(Me.[NameOfYourListBoxHere])

Any reason for using "Call..." instead of

DoSomething me.lstWhatever

?
--
PeteCresswell

[Allen Browne]

Call is optional.

I prefer it because because:
a) It works in all versions, regardless of whether DoSomething is a Sub or
Function.
b) It standardizes the way arguments are passed (bracketing.)
c) It distinguishes a user-defined procedure from a built-in keyword.
which to me seems more consistent and readable (so maintainable.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"(PeteCresswell)" <[e-mail]> wrote in message
news:ob********************************@4ax.com...

Per Allen Browne:

Then call it like this:
Call DoSomething(Me.[NameOfYourListBoxHere])

Any reason for using "Call..." instead of

DoSomething me.lstWhatever

?
--
PeteCresswell

[Zlatko Matiæ]

OK. it should be declared as Control.

"Zlatko Matiæ" <zl***********@sb.t-com.hr> je napisao u poruci interesnoj
grupi:dq**********@ss405.t-com.hr...

I would like to pass full name (path) of a list box (ListBoxName) to a
function, so that I can reference it inside the function as
ListBoxFullName.Column(0, varItem).
How should I declare ListBoxFullName ? As object, name, string or
something else?

Zlatko