Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have created an address table that I would like to use in a form via a
drop down that would show all address fields. How can I make my selection
show all the detail for each record instad of only the first field (name)?

Name
Attn
Address
City, St Zip
 
Renetta

It's not quite clear if you want to have your form bound to the underlying
address table, or if you want to have an unbound form that, nevertheless,
displays a specific address table row.

Either way, if you create a combo box ("drop-down") on your form and use the
address table as your source for the list it generates, you can use the item
selected in that combo box. Assuming you have the rowID as the first field,
you can use the combo box's AfterUpdate event to requery the form and "get"
the corresponding record.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You will not get it in this format:
Name
Attn
Address
City, St Zip
You could get:
Name Attn Address City, St Zip

That you can do a number of ways depending on what you intend to do. A
multi column Combo Box a Multi Column List Box, A continuous form, or a
datasheet form.
 
Any suggestions how I can pull the table and all its fields into a form? I
don't want to have to retype redundent info.
 
Renetta

Open Access. Click on the <Tables> tab. Highlight the new table you've
designed. Click on the <New Object> Toolbar button. Select either AutoForm
or Form Wizard (names may vary by version).

Either way, you'll end up with a form based on the table.

As an alternative to keep in mind, create a query based on the table, then
create your form based on the query. This makes it easier to sort records,
select certain (sub-)sets of records, etc.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Any suggestions how I can pull the table and all its fields into a form? I
don't want to have to retype redundent info.
Click to expand...

That's not what Klatuu is suggesting.

A Form is JUST A WINDOW - a tool to manage data stored in Tables.

You can use the "Autoform" tool on the table toolbar to create a Form
which will display (and allow you to edit) all of the fields in your
table. You can then customize this form to look however you wish.

John W. Vinson[MVP]
 
I'm going to try this. Thanks.

John Vinson said:
That's not what Klatuu is suggesting.

A Form is JUST A WINDOW - a tool to manage data stored in Tables.

You can use the "Autoform" tool on the table toolbar to create a Form
which will display (and allow you to edit) all of the fields in your
table. You can then customize this form to look however you wish.

John W. Vinson[MVP]
Click to expand...
 
I'm not sure I'm explaining this correctly. I have a table with say 3 diff.
addressee's Name, Address, City State zip. I want to be able to select the
appropriate address within my form (which would/could if possible be formated
to look like a letter) without having to retype the address hence creating a
new record if the record already exsists it should appear. Again, I should
be able to modify the formate instead of it appearing like a string of
information.
 
If I use a drop down via a combo box
1) how do I get all fields to appear?
2) Can that be formated to look like a letter via the form?
 
I'm not sure I'm explaining this correctly. I have a table with say 3 diff.
addressee's Name, Address, City State zip. I want to be able to select the
appropriate address within my form (which would/could if possible be formated
to look like a letter) without having to retype the address hence creating a
new record if the record already exsists it should appear. Again, I should
be able to modify the formate instead of it appearing like a string of
information.
Click to expand...

It's important to separate the three quite different tasks of data
STORAGE, data EDITING, and data PRESENTATION. Data is *stored* in
Tables; it's entered and edited through Forms; and it's printed using
Reports. You don't need to reenter or retype an address when it's
already been entered once! You are using a database; that's what
databases DO - store, retrieve, and present data.

The Report should be based on a Query selecting the correct record
from your Table. The Report can have the fields in the table laid out
however you wish, e.g.

[Name ]
[Address1 ]
[Address2 ]
[City ][ST] [Zip ]

This layout of fields has absolutely NOTHING to do with how the fields
are arranged in table design, or how they appear in a table datasheet
(or even on a Form). You use the Report Designer to set up the report
how you want the values to appear on the page.

The Query would be designed to select whichever address you wanted
printed on the paper. It could use a criterion such as

=Forms![YourFormName]![ComboBoxName]

to select the appropriate record for printing.



John W. Vinson[MVP]
 
Back
Top