I'm trying to build a messaging centre into my database, I have a login for that points to a menu. From this menu, I want it to open another form to compose a new message to be sent to a user/users within the database.

What I need it to do is when I click the button to compose a new message, I want the drop down box for "from" to be autocompleted/filtered based on the user that is logged in on the previous menu.

I have managed to do this before but for some reason I can't think the way I did it!! any help would be appreciated.