What's the easiest way to do these? I hear you gotta use 2 recordsets but I'm still not clear on how it's done. Basically it's gonna be a drop down populated by the list of USERS in a recordset.

The first recordset is the recordset that holds the list of users. Maybe just one column. This is what the dynamic dropdown can select. If you want the dynamic drop down to choose a particular user then have the second recordset choose according to an ID(maybe primary key)
ie select *
from students where studentid='varstudentid'

Then choose from the UD or MX properties of the dynamic list box and select "Select value equal to...." and choose from your recordset your users column.

This will show your 'user' from a list of among all users.