Using Form to Input Table Data

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

Guest

I don't exactly know how I did it, but I designed a form in a database into
which I can input my data and at the end of the last form entry another Enter
saves the record into my table. I'm trying to do this again, but I'm running
into this problem. When I input the last entry into the form another Enter
just takes me to the same record at the first Tab, instead of entering the
new record. What am I missing?
 
I don't exactly know how I did it, but I designed a form in a database into
which I can input my data and at the end of the last form entry another Enter
saves the record into my table. I'm trying to do this again, but I'm running
into this problem. When I input the last entry into the form another Enter
just takes me to the same record at the first Tab, instead of entering the
new record. What am I missing?
Click to expand...

Set the Form's Cycle property (on the Form property sheet's Other tab)
to All Records
 
The Form cycle property IS set to All Records. But I cannot even use the form
record controls to add a new record. My first and last entries on the form
are combo drop down menu boxes where the user can select from a list of
options. The combo boxes' control sources are fields in other tables. I can
make the selections fine and enter in the other data, but when I get to the
end the whole thing just cycles back up to the top without any entry.

OK, let's start at the beginning with a simple example.
Say, I have a table with one field. I want to create a form so when I make
an entry into the form my table will automatically be updated with that entry.
 
OK, I figured out how to get the form to work to input data, but how do I get
the default values in the form entries NOT to remain - or to be blank before
an entry.
 
Back
Top