cannot edit record in form

[nicholas]

Hi!

Got following problem:

I have a form to insert data. (= creates new records)
I have another form to search existing records.
When a record is found, I select and open it to edit it.

Problem is that I can see everything but cannot edit it.
All properties are OK (form properties and field properties)

The form is linked to the table (not to query). But I tried linking it to
query and got same problem.
Any idea what could be happening?

PS: sent previous post where I mensioned the "data entry" property, but this
property is only for new record creation.

Thanks!
Nic

 

[Al Campagna]

Nic,
If the form is based on a table, and the table is updateable, so should the form.
What are your Allow properties set to (AllowEdits, Allow Deletions,...etc) for the Edit
form

Problem is that I can see everything...

Are you unable to edit an exisiting record, or just a new record.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[nicholas]

Hi,

Thx for your reply.
AllowEdits, etc are set to yes.

Maybe one thing: the tables are in another mdb-file.
In the mdb-file with the forms, I inserted the linked tables.
Could this be the reason?

Thx again!

 

[Al Campagna]

Nic,*Did you try editing the table directly in whatever mdb the failing form is in?
Use a query as a RecordSource for the form. Hust include all the fields, and it's the
same as using a table.
*Now... if you run the query behind the form, is it updateable??

If you can't edit the table directly, or your query behind the form is not updateable,
then Your link (or some other complication is amiss)

*Also, try moving the failing form to the mdb where the table resides, to see if you
have the same problem.

Pretty hard to tell what the problem is "remotely", but you first must determine if the
table is updateable, and then is the query updateable.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[nicholas]

Hi,

Thx for all you help!

Table is updatable.
Created new form to see and that-one works fine.

Also found out something new:

normally I use my search-form and then open the final form to edit it.

but if I go to "forms" in access and open the form directly: it works: I can
edit it.

So it's just when I use my search form and open my form that I cannot edit
it.

Weird......

Anyway, if you got an idea, would be great.

Thx!!
Nic

 

[Al Campagna]

Nicholas,
You have to read the responses carefully... and answer all questions, whether they
appear related or not.

You said the "table" was update-able, and the Edit form can be opened manually, and
works that way?

You'll have to explain where each of these forms (and their associated tables are
located).
And show your code you use to open the "edit" form from the search form. (Copy & Paste
exactly)
Not really...
The difference between opening a form manually, and open by code, are the OpenForm
method arguments in the code.
Review each of the OpenForm arguments in the code that opens the Edit form.
Check that your arguments and commas are correct. Particularly the DataMode
argument...
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."