Access Form To Table Linking?

[KevinRS]

New to Access here, and have a question. I’m trying to make an Access DB that
will draw data from a table in the database, I’m not sure how to link the
form and table together. The data that is being pull was given to me in a row
by row format. What I want to do is withdraw data from say Cell A2 in to a
form when a person is typing the name of a client. Once the last name is
populated I wanted to make it pull the entire row from the imported Excel
doc. Ex. A3---to Form Textbox 2, A4---to Form Textbox 3…ect. So when the
person is typing a name the information in the table will automatically
appear and further questions can be asked.

 

[strive4peace]

Hi Kevin,

the source of a form is called the RecordSource property -- you can
specify a table, query, or SQL statement for this

for better understanding of the basics of Access, read this:

Access Basics (on Allen Browne's site)
http://www.allenbrowne.com/casu-22.html
8-part free tutorial that covers essentials in Access

Allen has a wealth of information on his site; after you get to the
bottom of this link, click on 'Index of Tips'

Warm Regards,
Crystal


*
have an awesome day
*

 

[John W. Vinson]

New to Access here, and have a question. I’m trying to make an Access DB that
will draw data from a table in the database, I’m not sure how to link the
form and table together. The data that is being pull was given to me in a row
by row format. What I want to do is withdraw data from say Cell A2 in to a
form when a person is typing the name of a client. Once the last name is
populated I wanted to make it pull the entire row from the imported Excel
doc. Ex. A3---to Form Textbox 2, A4---to Form Textbox 3…ect. So when the
person is typing a name the information in the table will automatically
appear and further questions can be asked.

And what do you plan to do when there are three clients all named Fred
Brown...?

Read Crystal's suggested links. Access IS NOT A SPREADSHEET, and does not have
cells; what you're going to want is a form with (probably) a combo box
*displaying* a client's name and other fields which will allow the user to
unambiguously identify the client, and *storing* a unique client ID.