your filtering the recordset on the UserID session variable.
do not fil;ter the recordset.
the idea is to show a list of all users, pass the selected user ID to the confirm page.
on the confirm page, set a recordset to filter on the selected User ID, and use that recordset to populate the users info in the orders table when the order is confirmed.
if you need help setting this up, I suggest signing up for a premiere support appointment.