Do I need such detailed references

[mdavid]

Hi, I have a listbox on a subform and I want to display the .ListCount property underneath it, the following displays this

Forms![MempBercMainFrm2].[Form]![MempBercListBox].[Form]![txtTotMemp] = Forms![MempBercMainFrm2].[Form]![MempBercListBox].[Form]![lstbMempComplaints].
[ListCount]

What I was wondering is if there is a way to shorten this expression? Gets really tiring writing out these long qualifiers every time

Thanks for any help
David

[pbaldy]

Where is the code? You can use "Me." as a shortcut to refer to the object containing the code. If the code is in the subform, it could simply be:

Me.[txtTotMemp] = Me.[lstbMempComplaints].
[ListCount]

[mdavid]

Sorry to waste your time - but if I hadn't asked I wouldn't have thought of writing =[lstbMempComplaints].
[ListCount] in the Control Source.
Just needed someone to talk to.

Thanks
David

[pbaldy]

Always glad to lend an ear.

[mdavid]

Hi Paul, I tried to do this, but when I typed "Me." into expression builder I didn't receive any options so I thought it wasn't right

[pbaldy]

Me is only valid in VBA code. It wouldn't work in a control source, query, etc.