Forms for data entry

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

Guest

I have created a number of tables which are linked to one form. My hope is
that multiple users can enter data into my tables via the form, but I cannot
get my form to add new data. It will only capture test info that I have
input directly into the tables. I have tried all of the previous suggestions
from past discussions and nothing is working. Can anyone help me?
 
Juls said:
I have created a number of tables which are linked to one form. My
hope is that multiple users can enter data into my tables via the
form, but I cannot get my form to add new data. It will only capture
test info that I have input directly into the tables. I have tried
all of the previous suggestions from past discussions and nothing is
working. Can anyone help me?
Click to expand...

Queries based on multiple tables are often not editable. Can you open the
query the form is bound to directly and make edits there?

A better practice is to use forms with subforms having each form bound to
only a single table (or a query based on a single table).
 
i assume the RecordSource of your form is a query. not all queries,
especially multi-table queries, are updateable. try opening the query by
itself and adding a record. if you can't, pls post the query's SQL statement
so we can look at it.
 
Juls,

If your form is *displaying* data correctly that has been entered, it is
very likely that the query underlying the form is "non-updateable". There
are many possible reasons for this. Try a Google Search on "non-updateable
query" to find a Microsoft White Paper on the subject, or post the SQL.

Sprinks
 
Thanks for responding. I recieved 3 responses with the assumption that the
record source for my form is a query. I am relatively new to access so it is
probrably me doing something wrong, but the record sources for my form are
three tables not queries. I don't know if that changes your suggestions, but
I am open to just about anything right now.
 
the record sources for my form are three tables not queries

a form can have only one RecordSource at a time (even if you're changing it
programmatically from time to time). do you mean that you have subforms on
the form? and the RecordSource of the mainform and each subform is a table?
 
Hi,
A form can only have one record source, so you it can't have 3 tables.
It either has a query (which means you can have data from more than one table)
or a single table.
In case you're not clear on this, with your form open in design view, what ever shows up
in the Record Source property is the form's record source.
 
I used the forms wizard to create my form and within the wizard is the option
to select data from more than one table source. I also have a book that I
have been using a my guide from training which also suggests that this is ok.
So maybe my problem is as you have suggested I should only be using one
table. I have now created three auto forms for each table and will see what
I can do with these. Thanks.
 
Hi,
Okay, so your record source is a query. Sometimes queries are not updateable
and that is probably what is happening with your form.
 
when you use the Forms Wizard and select fields from multiple tables, the
wizard creates a SQL statement to use as the form's RecordSource. this is
basically a "query" that is not saved as a query object in the database. so
the stipulation that
not all queries, especially multi-table queries, are updateable
Click to expand...

applies here as well. in this situation, you can check whether or not the
recordset is updateable as follows: open the form in design view. open the
Properties box. click in the RecordSource property, you'll see an ellipsis
(...) button at the right side. click the button. a window that looks like a
query design view opens up. on the menu bar, click the View button. if you
can add a record, the form's recordset is updateable. if you can't, it's not
updateable.

btw, if anyone asks to see the "SQL" or the "SELECT statement" in this
situation, you can copy it directly from the RecordSource line in the form's
design view.

hth
 
Check your forms properties.
- allow additions - is set to yes
- allow edits - is set to yes

Also, you could create different forms from each table.
AND... You can drop these three forms onto a new form, and all three will be
visible on the one form. You can do the same with reports, to a point.

Mike Schlosser
 
Back
Top