Beginning ADO help?

[Beeps]

Hi all,

I'd like to use ADO to look up a value in a query/table and I've got as far as this:

Static rsBill As ADODB.Recordset
Set rsBill = New ADODB.Recordset

rsBill.Open "Bill", CurrentProject.Connection, adOpenStatic, adLockReadOnly

I'd like to get information from the records in "Bill" (Specifically "Billing ID&quot based on criteria and pass it a bound control.

How do you get information from the recordset? Any ideas?

Thanks!