Cannot edit some of my forms why??

Hi, i have 27 forms, where each one of them is build on an querie (Question)
that is specific for each form. All Queries is build on the same table. Of
all the 27 forms i can only edit 20 of them, the first 7 i made is inpossible
to edit. I have checked in the configuration for these 7 forsm and edit is
allowed. I can see nowwhere there it stans that edit is not allowed but
anyway it dosent work, why is it so?
Please help.
Regards

"Nordivan" wrote

Hi, i have 27 forms, where each one of them is build on an querie
(Question)
that is specific for each form. All Queries is build on the same table. Of
all the 27 forms i can only edit 20 of them, the first 7 i made is
inpossible
to edit. I have checked in the configuration for these 7 forsm and edit is
allowed. I can see nowwhere there it stans that edit is not allowed but
anyway it dosent work, why is it so?

My crystal ball isn't working properly today, so I'll just have to offer you
some suggestions for beginning to debug:

Try running the Query from the Query Builder (the one you are using for
RecordSource for a Form you cannot edit), and try to edit the values -- if
the Query is not updateable, it will still be un-updateable when used as
RecordSource for a Form.

Are you getting an error message? If so, what is it, exactly? If not, have
you got an ON ERROR RESUME NEXT statement that might be suppressing the
message?

Larry Linson
Microsoft Access MVP

Hi, i got no error messages, i just hear an sound when i click into one of
the textboxexs in the form and if i mark the text in the text box and press
delete i also hear the same sound. The info in the the textbox is still
there. I`ll try running the Query from the Query builder.
Thanks
"Larry Linson" skrev:

"Nordivan" wrote

Hi, i have 27 forms, where each one of them is build on an querie
(Question)
that is specific for each form. All Queries is build on the same table. Of
all the 27 forms i can only edit 20 of them, the first 7 i made is
inpossible
to edit. I have checked in the configuration for these 7 forsm and edit is
allowed. I can see nowwhere there it stans that edit is not allowed but
anyway it dosent work, why is it so?

My crystal ball isn't working properly today, so I'll just have to offer you
some suggestions for beginning to debug:

Try running the Query from the Query Builder (the one you are using for
RecordSource for a Form you cannot edit), and try to edit the values -- if
the Query is not updateable, it will still be un-updateable when used as
RecordSource for a Form.

Are you getting an error message? If so, what is it, exactly? If not, have
you got an ON ERROR RESUME NEXT statement that might be suppressing the
message?

Larry Linson
Microsoft Access MVP

After i delete the queries and runned them thru the query builder it works
fine now, thanks for the help.

"Nordivan" skrev:

Hi, i got no error messages, i just hear an sound when i click into one of
the textboxexs in the form and if i mark the text in the text box and press
delete i also hear the same sound. The info in the the textbox is still
there. I`ll try running the Query from the Query builder.
Thanks
"Larry Linson" skrev:

"Nordivan" wrote

Hi, i have 27 forms, where each one of them is build on an querie
(Question)
that is specific for each form. All Queries is build on the same table. Of
all the 27 forms i can only edit 20 of them, the first 7 i made is
inpossible
to edit. I have checked in the configuration for these 7 forsm and edit is
allowed. I can see nowwhere there it stans that edit is not allowed but
anyway it dosent work, why is it so?

My crystal ball isn't working properly today, so I'll just have to offer you
some suggestions for beginning to debug:

Try running the Query from the Query Builder (the one you are using for
RecordSource for a Form you cannot edit), and try to edit the values -- if
the Query is not updateable, it will still be un-updateable when used as
RecordSource for a Form.

Are you getting an error message? If so, what is it, exactly? If not, have
you got an ON ERROR RESUME NEXT statement that might be suppressing the
message?

Larry Linson
Microsoft Access MVP