How do I get ADODB.Recordset data to appear in an Access form ListBox?

I have two tables "staff" and "members"
When a user opens the database they use my "login" form
which, given the correct information, sends staff the my "staff" form.
For the "staff" form to know which user had logged in i have used a
'Global veriable'; "OffsetPos" which is set during the login and can
be successfuly called from the "Staff" form. I need to bring up a list
using a ListBox controle in the "staff" form containing details from
the "members" table but only for members who have their "personal
staff" field set as the current loged-in staff member (the offsetPos
value.)

I can not seem to use the global veriable in an expresion in the query
criteria wizard. So i have succsesfuly used the forms code to open a
recordSet and use its filter function to generate the results i need.
HOW do I get the recordset data to appear in a form ListBox???

You can use global variables in a query if you first create a public
function to expose the value.  In a module, create the following:

Public Function GetOffsetPos() as Variant
  GetOffsetPos = OffsetPos
End Function

You may want to change the type "Variant" to match the type of
variable you used when declaring the OffsetPos variable.  You might
have used "String" or "Integer", or if you didn't specify a type then
"Variant" is fine.

When you write the query to populate the listbox, just set the
"criteria" for the field you are looking for to GetOffsetPos().

-Stolis