not able to enter data on forms

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

Guest

I designed a form based on a query. The form has numerous tab pages ( about
15). The relationship is a one to many relationship. The join type is
option 2: include all records from School Info and only those from equipment
were the join fields are equal. The query works fine but I am unable to
enter data into the form itself.

There is no error message, the keyboard just beeps.
 
Tami said:
I designed a form based on a query. The form has numerous tab pages
( about 15). The relationship is a one to many relationship. The
join type is option 2: include all records from School Info and only
those from equipment were the join fields are equal. The query works
fine but I am unable to enter data into the form itself.

There is no error message, the keyboard just beeps.
Click to expand...

Not all queries are updateable. Queries with more than one table in them
are often not. If you bind a form to a query that doesn't allow edits then
the form won't allow them either. Try entering data directly into the
datasheet of your query. You will likely find that you cannot do so.

There is an entire help topic "When can I update data in a query?" that you
should read. In some cases the query's design can be tweaked to make it
allow edits (sometimes not). In general using forms with subforms each
bound to a single table is the better way to handle data entry.
 
Tami said:
The strange thing is I can enter data into the datasheet.
Click to expand...

You are talking about the datasheet of the form's RecordSource right? You
went to the RecordSource property and clicked on the build button [...]
which took you to design view of the RecordSource's query which you then
switched to Datasheet view and tried to edit something. If that is not what
you did then you might not have been in the correct datasheet.

If that IS what you did then you would have to check the RecordSourceType of
the form (make sure it is not set to "Snapshot") and also check the
AllowEdits property.
 
I know that i was directed to the right place. It was on dynaset and i
changed it to dynaset (inconsistent updates) and I am now able to enter data.
Not sure why? And what effects this will have on data entered.

Rick Brandt said:
Tami said:
The strange thing is I can enter data into the datasheet.
Click to expand...

You are talking about the datasheet of the form's RecordSource right? You
went to the RecordSource property and clicked on the build button [...]
which took you to design view of the RecordSource's query which you then
switched to Datasheet view and tried to edit something. If that is not what
you did then you might not have been in the correct datasheet.

If that IS what you did then you would have to check the RecordSourceType of
the form (make sure it is not set to "Snapshot") and also check the
AllowEdits property.
Click to expand...
 
Back
Top