help wtith database please

[mmm455]

i am having trouble with the database i am creating.. help would be very much appreciated.

i would help to link the forms of my database together, so that i can navigate from each page to another part of the database. also i nwant the data base to have a main menu so that by clicking on a button on the main menu, it will naigate me to the relevant page. How do i go about setting this up?

Also, what is the calculation that will get the two seperate fields (forename and surname) to display together as a full name?

 

[maxmangion]

Also, what is the calculation that will get the two seperate fields (forename and surname) to display together as a full name?

Create an unbound textbox and set the following as its control source

=[FirstNameFieldName] & " " & [LastNameFieldName]

Make sure that your replace the above with the actual names of your fields.

As regards the other question try searching for "switchboard".

 

[mmm455]

ok thank you

 

[maxmangion]

you're welcome.