Form Issues

[Problem.]

Basically, I have a database, currently with only a one row entry in a table.
I also have a form, with entry fields for the specific column headers in the
table. What I ultimately want to accomplish, is basically an "entree sheet"
where I can constantly input data into the table using the entree fields,
while still being able to use the form to refer to a previously entered
entree. I'm not sure where to go from here, cause I can't figure out what to
do next.

 

[Beetle]

You can use a continuous (tabular) form or a datasheet to view multiple
records at once if that is what you mean.

 

[Linq Adams via AccessMonster.com]

Not to be unkind, but you obviously have absolutely no idea of what you're
doing. Despite Micro$oft's hype, just "anyone" cannot develop a database
using Access! You need down to go to your local bookstore and pick up, at the
very least, a basic "how to" book and read it it, cover to cover. "Access for
Dummies" or the equivalent would be an excellent place to start. It'll give
you some general background, enough knowledge to get started, and basic
terminology so that you can ask clear questions here.

Good luck!

 

[Problem.]

Unfortunately, I do know how to set up a database, but what I'm currently
trying to do is evidently more advanced beyond the scope of my basic
knowledge of how to set up a database. If it was just tables, with
information, I'd be ok. I will try to reiterate what I'm trying to accomplish.

I have a table, with column headers. It currently only has one row of
information.

I have a form, with entry fields linked to those column headers.

What I would like to do, is use that form to not only write information to
that database, but also use it to pull up information on a particular entry
in the table.

For example:

Heres a basic form outline:
Customer Name:
What Was Purchased:
Purchase Price:

What I would like to do, is able to type in that form, Customer A, Access
2003, $100, in those fields, respectively, and it will write to the table
that was already created. Now in addition, I would like to be able to pull up
information in the form. For example, I select "Customer A" from a drop-down
in the Customer Name field, and the other fields would get filled in as well,
displaying information relevant to Customer A.

Hope this helps.