Developing Forms With Query-Data Entry Problem

[Guest]

Using WinXP, Access2002

I don't remember running across this problem in the past, but lately when I
create a form with a query, the form will not allow data changes nor adding
records. I read several discussion articles about 'forms by queries' and I
should not be having this problem.

Opening the form's properties, under the Data tab, 'Data Entry' is set to
'Yes'.

In 'References' I have Visual Basic For Applications; Microsoft Access 10.0
Object Library; OLE Automation; and Microsoft ActiveX Data Objects 2.1
Library. I noticed that 'Microsoft DAO 3.6 Object Library' is not checked.
Could that be the problem?

Thanks in advance.

 

[Rick Brandt]

Using WinXP, Access2002

I don't remember running across this problem in the past, but lately
when I create a form with a query, the form will not allow data
changes nor adding records. I read several discussion articles about
'forms by queries' and I should not be having this problem.

Opening the form's properties, under the Data tab, 'Data Entry' is
set to 'Yes'.

In 'References' I have Visual Basic For Applications; Microsoft
Access 10.0 Object Library; OLE Automation; and Microsoft ActiveX
Data Objects 2.1 Library. I noticed that 'Microsoft DAO 3.6 Object
Library' is not checked. Could that be the problem?

Thanks in advance.

That is a property of the query, not of the form. Some queries are not
editable. If you bind a form to such a query then the form is not editable
either. Work on your query as a separate entity and see if the design can
be tweaked until it allows edits in its datasheet view. Only then can you
expect to bind it to a form and do edits from there.

 

[Guest]

Rick,
I went back to my Query, realized I was trying to join two unrelated tables.
Taking out one of the tables in the query allowed the editing/addition of
records via the form.
Thanks for the help.