Here is the Access Database I need help with:

Database

user login David with password david

I am not worried about layout or design, after I get it working right I will create a nice interface, just need help with the following:

Here are my problems.

1. When user logs in I want that users name to be displayed on the form (frmSupply) in the Receiver at TMO textbox.

2. On the form (frmSupply), when a user selects Items belong to:, I want the coresponding RA's info to show up in the RAs Information textbox. Or maybe two textboxes (one RA name, one RA number). This info is all in the Table (tblSquadrons).

3. On the form (frmSupply) I have a Mail button and Print button (been playing around trying to find a way to email a record) I will change the icons later, for now I am trying anyway possible to send the current records contents by email. I like the way the Print button hyperlinks to email, instead of having to select a format.

That's it. If I can figure out these problems I would greatly appreciate it. I have no code experience so try to keep it simple.