How do I make a form to pull only certain info from a database?

H

Heather D.

I am trying to create a Word document that will allow me to pull information
from a database that changes. Both the information and database will change,
but the form will be a standard.

I want to be able to pull item from a drop down - then have it autofill
across the additional information for that item.

I would love any help and suggestions - including whether to set up database
in access or excel - or to create form in word or access?

Thanks!
 
J

Joseph Meehan

We need to know some additional information. Normally a database as
many records often with complex relationships. You will need to have a way
of filtering or selecting the specific data you want. Since there are
changes taking place that you may not control, and I don't know who is
controlling etc. I can't suggest any specific solutions. But I am certain
you need to get together with whoever is controlling the database (Access?)
and work things out. They likely will be able to help you depending on the
level of their training.
 
B

Beth Melton

Heather D. said:
I am trying to create a Word document that will allow me to pull
information
from a database that changes. Both the information and database will
change,
but the form will be a standard.

I want to be able to pull item from a drop down - then have it autofill
across the additional information for that item.

I would love any help and suggestions - including whether to set up
database
in access or excel - or to create form in word or access?
Click to expand...

If you can program and create a connection using ADO or DAO between Word (or
Excel) and Access then use Word or Excel along with a UserForm bound to your
Access database. If you aren't a programmer then use Access since it was
designed to do exactly what you want. It sounds like what you need is an
Access report.

Another alternative is to use Word and mail merge and filter the recordset
from the database to obtain the record you merge for your form. In this
scenario, whether you use Access or Excel depends on how complex your
database is.

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx
 
Top