Enter data into a query

[CTQE]

Hello All,
I have been away from Access for a while & I forgot how to a create a query where in a Datasheet view I can enter data & it will update the table.

Thanks in advance

 

[CTQE]

For some strange reason a pre-existing select query did not allow for a field to be updated.

I created another select query and whatever was blocking that update was not present with the new query.

Unless someone would like to explain this wierd occurrence, I would consider this issue closed.

 

[boblarson]

For some strange reason a pre-existing select query did not allow for a field to be updated.

I created another select query and whatever was blocking that update was not present with the new query.

Unless someone would like to explain this wierd occurrence, I would consider this issue closed.

You might consider reading this for future reference.