Two questions regarding setting up a form

Tech-Archive recommends: Fix windows errors by optimizing your registry

Can someone help me with a couple of questions I've got regarding my first
access database I'm setting up.

1. I've created a form that contains two textboxes, amongst other things.
One of these text boxes is username and the other is email. The email takes
the form of whatever they put in the username field plus the text
"@domain.co.uk". So at the moment for each record I have to type the
username then retype the username in the email textbox with the above text
appended on at the end. How can I get the text from the username to
automatically get copied over to the email text box with the "@domain.co.uk"
copied across? Ideally this would happened automatically when I exit the
username field.

2. The second question regards another two components on this form, two
comboboxes. The first combo contains a list of department heads while the
second combobox contains a list of departments. At the moment I have to
manually select the department and then select the department head form the
second dropdown. I want it so if I select a department, the department head
combo changes to reflect the head for that department, and vice versa. So I
know for instance if I select the 3 option under department then option 5
will need to be selected under department head.

Any help with this would be great. Many thanks




.

Relevant Pages

  • Re: Two questions regarding setting up a form
    ... > One of these text boxes is username and the other is email. ... > the form of whatever they put in the username field plus the text ... > second combobox contains a list of departments. ... > will need to be selected under department head. ...
    (microsoft.public.access.gettingstarted)
  • Re: Two questions regarding setting up a form
    ... Include your DeptHeads in the cboDepts query. ... > One of these text boxes is username and the other is email. ... > second combobox contains a list of departments. ... > will need to be selected under department head. ...
    (microsoft.public.access.gettingstarted)
  • Re: Two questions regarding setting up a form
    ... >> One of these text boxes is username and the other is email. ... >> username then retype the username in the email textbox with the above ... >> second combobox contains a list of departments. ... >> will need to be selected under department head. ...
    (microsoft.public.access.gettingstarted)
  • Re: Two questions regarding setting up a form
    ... In the AfterUpdate event of the first textbox, ... and determine the Department Head from the Department? ... Private Sub cboDepartment_AfterUpdate ... > One of these text boxes is username and the other is email. ...
    (microsoft.public.access.gettingstarted)
  • Re: Trailing spaces padding out cells?
    ... "Russell" wrote in message ... > stored proc to create them. ... The username field is a varcharand the ...
    (microsoft.public.sqlserver.server)