just set up a 3-tab form but it won't let me enter data? just beep

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

Guest

Access 2003
it also will not let me add a new record, i.e., student?
Form is to enter new students
Tabs are: General Info, Education and Degree Info, and HR Info
Some tables had more data than others. I'm trying to use this form to help
fill in missing data for all students, and also add new students and their
data
I've been adding fields to my forms as I've added each tab - adding fields
to the field list each time through the form query.
 
Are you using subforms on the tabs? I believe you would have to. Have you
tried to view the datasheet view of your form's record source to see if you
can edit records there?

It sounds like you have multiple one-to-many type relationships that will
only work if you use subforms.
 
Hi,
on - no subforms, I just dragged the fields from the field list onto the
tabs - they look really nice but won't let me enter anything? I can scroll
through my existing data and view it all on my tabs, but it won't let me edit
or add anything to fill in those blanks I'm trying to clean up in the records

I went to back to the tables as you suggested and I can add data fine and
lookups all working fine...I have about 15 related tables that I've created
and trying to create one place to enter/edit the data for each student -
thought tabs would give keep me organized?
 
tables let me enter data just fine

I have about 12 related tables and trying to create one place for
entering/editing records using tabs? I just dragged and dropped the field
names from the field list onto the tabs - that doesn't work? It looks so
friendly now. I looked at the subform and it makes that "horizontal
spreadsheet" looking things - not very nice looking? Is that my only option?
 
cathknits said:
Hi,
on - no subforms, I just dragged the fields from the field list onto
the tabs - they look really nice but won't let me enter anything? I
can scroll through my existing data and view it all on my tabs, but
it won't let me edit or add anything to fill in those blanks I'm
trying to clean up in the records

I went to back to the tables as you suggested and I can add data fine
and lookups all working fine...I have about 15 related tables that
I've created and trying to create one place to enter/edit the data
for each student - thought tabs would give keep me organized?
Click to expand...

The wizards are misleading in this area because they suggest that you can just
add as many related tables as you want to your form RecordSource. The truth is
that queries based on more than one table are not really suited to forms where
you want to edit data. It *can* be done with just a couple of tables, but the
more tables you add the more likley that the query will no longer allow edits.

In forms, the best bet is a parent form with subforms with each one bound to a
single table.
 
You need to use subforms if you want to be able to edit related records.
Subforms can be formatted as single form, continuous, or datasheet.
 
Back
Top