Memo Field - Won't allow type

S

ShawnaZ

I have a memo field that will allow me to type into the field in the table or
a simple query but when I create a query using two tables the memo field will
not allow me to enter data into it.

I do not get an error. the computer bings and my keyboard is inoperative.

Any suggestions
 
M

Mark Andrews

Certain queries are not updatable. If you open the query by itself and you
can't update data the same thing will happen if you base a form on that
query.

Solution is to create a query that is updatable and then base the form on
that query.

hard to help in other ways without more detail (try posting the sql of the
query),
Mark
 
B

Brian

Please post the SQL of the query. Under various circumstances, queries become
read-only when the data comes from multiple sources, such as when there is a
Group By in the query.
 
T

TedMi

Some queries cannot update the data on which they are based. Search Access
help for "edit data in a query"
-TedMi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top