I can't edit a field's value in a query

C

Capt Jim Cook

Help. I have a simple query that displays selected fields for non delivered
items from a table of deliveries. We use julian dates stored as numbers and
times stored as text fields (I didn't create it this way, I inherited it).
The fields "Delivered Date" and "Delivered Time" are usually updated from a
handheld scanner device, but some items don't get scanned. "Delivered Date"
contains a zero and "Delivered Time" is empty until updated by the scanner
data.

I select records by using zero in the criteria for the "Delivered Date" and
want the users to manually enter a date and time for items that didn't get
scanned. The query looks good and shows the correct records, but I can't
enter any data from the keyboard, it just beeps when you press a key.

I can open the table and enter data, but can't enter it using the query.
 
D

Duane Hookom

Is your table an Access table? What is the SQL view of your query? Are all
joins based on a primary and foreign key?
 
C

Capt Jim Cook

Thanks!
It is an Access 2000 table. I set a primary key on the linked table (I'm
not looking at all rows, just ones that match a specific list of part numbers
stored in another table) and now it works fine.
 
Top