If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form title
I created a simple form based on a table called Soldier Personal Data
with fields called Last Name, First Name, Rank. The table has 47 records in it at this time. The form is simply called Soldier Personal Data Form but I would like to show the individual Soldier's Rank, first and last name, when I as I look at. Can I do this? Thanks for your assistance. |
#2
|
|||
|
|||
Form title
How is this a .tablesdbdesign question?
If you want a form to display data in an underlying query (preferred) or table, open the form in design view and add a control to display that field. Regards Jeff Boyce Microsoft Office/Access MVP "Anthony" wrote in message ... I created a simple form based on a table called Soldier Personal Data with fields called Last Name, First Name, Rank. The table has 47 records in it at this time. The form is simply called Soldier Personal Data Form but I would like to show the individual Soldier's Rank, first and last name, when I as I look at. Can I do this? Thanks for your assistance. |
#3
|
|||
|
|||
Form title
Open the form in design view and drag the objects to where you want them
displayed. -- KARL DEWEY Build a little - Test a little "Anthony" wrote: I created a simple form based on a table called Soldier Personal Data with fields called Last Name, First Name, Rank. The table has 47 records in it at this time. The form is simply called Soldier Personal Data Form but I would like to show the individual Soldier's Rank, first and last name, when I as I look at. Can I do this? Thanks for your assistance. |
#4
|
|||
|
|||
Form title
Yes, you can.
The simplest way to get started is to create your table first. Every table should (read "must") have a Primary Key. Name a field SoldierID and make its datatype Autonumber. Create fields for the other data you will require. For ease of enhancement and maintenance of your application, avoid spaces in field names. Once your table is designed and saved, select it and click the Autoform Wizard Icon at the top of the window. Answer the prompts and make the choices and it will design a new form for you. You can do that any number of times until you get a form that you like or something close enough to what you want that you can later modify the design. When the wizard finishes you'll have a form suitable for adding or editing records. Using forms is a great leap forward for beginners. Another big step will be when you buy in on the idea that you use Reports do display and print data. HTH -- -Larry- -- "Anthony" wrote in message ... I created a simple form based on a table called Soldier Personal Data with fields called Last Name, First Name, Rank. The table has 47 records in it at this time. The form is simply called Soldier Personal Data Form but I would like to show the individual Soldier's Rank, first and last name, when I as I look at. Can I do this? Thanks for your assistance. |
Thread Tools | |
Display Modes | |
|
|