using forms for data collection

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

Guest

Hi, could someone check my logic. I think I'm doing the right thing, but
sometimes I get these scary doubts.

I'm building a form to collect data and send it to a table (VS. having data
in a table and seeing it on a form.0 Is this a legitimate use of Access?

The term "source field" keeps throwing me off, because my table is blank,
and so it's not really acting as a "source" to my form. I am linking each
control to a specific column (field?) on the table, of course, but my main
objective is for the user to compile a spreadsheet full of data by entering
it through forms.

My very basic Access guide book does not really discuss this use of Access.

Thanks in advance for any further clarity.
 
You can use a form for data entry by have the table as the source. You add a
new record, fill in the blanks and go to the next record or save and exit.

Data is automatically saved when you exit a field normally. If you enter
data in a field and leave the cursor in that field when you close the form it
will not save the entry in that field.

Alternatively you could have an unbound form (no source) annd use an event
or macro to append the data to a record in a table.
 
Hi, could someone check my logic. I think I'm doing the right thing, but
sometimes I get these scary doubts.

I'm building a form to collect data and send it to a table (VS. having data
in a table and seeing it on a form.0 Is this a legitimate use of Access?
Click to expand...

Look at the Form as a tool: it lets you display, enter, and edit data
in tables. Yes, it lets you view the data - but it lets you edit it
too. You don't need separate forms.
The term "source field" keeps throwing me off, because my table is blank,
and so it's not really acting as a "source" to my form. I am linking each
control to a specific column (field?) on the table, of course, but my main
objective is for the user to compile a spreadsheet full of data by entering
it through forms.
Click to expand...

What you're seeing is the "blank new record". It is a tabula rasa; the
record doesn't contain any information until you enter it... and then
it does. The record will be automatically written to the table the
moment you move off the record.
My very basic Access guide book does not really discuss this use of Access.
Click to expand...

Ummm... then you have a pretty poor guidebook, I fear! That's what
forms are FOR.
Thanks in advance for any further clarity.
Click to expand...

Hope this helps.

John W. Vinson[MVP]
 
I am having the same problem. How can I send the data from the form to the
table?
 
Back
Top