Form Issues

  • Thread starter Thread starter Problem.
  • Start date Start date
P

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.
 
You can use a continuous (tabular) form or a datasheet to view multiple
records at once if that is what you mean.
 
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.
 
Back
Top