Query beeps when entering value in field

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have a query that beeps when I attempt to add a new record. I can add new
records to the corresponding table, and I can change values in existing
records using the query. But when I bring up the query, click in the first
field of the new record, it beeps every time I press a key on the keyboard.

The query is based on two tables.


Any suggestions?
 
Yes. The asterisk appears in the left column of the last row. Whck I click on
the asterisk, the asterisk is replaced by an arrow. At that point I can enter
values in any of the fields in that row except the first field.
 
I have a query that beeps when I attempt to add a new record. I can add new
records to the corresponding table, and I can change values in existing
records using the query. But when I bring up the query, click in the first
field of the new record, it beeps every time I press a key on the keyboard.

The query is based on two tables.
Click to expand...

If the first field is an Autonumber field, you'll get this - autonumbers are
never editable.

If not, please post the SQL view of your query and indicate which field causes
the beep.
 
Back
Top