Unanswered: Lookup auto selected based on previous form
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.
sometimes simple is best.... and i'm just a simple fellow.