Query beeps when entering value in field

[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?

 

[Golfinray]

Is the query editable (the arrow and asterisk at the bottom highlighted?)

 

[Ken]

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.

 

[John W. Vinson]

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.

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.