Editing a Record on a form

G

glnbnz

I have a continuous form that displays records from a table. When I try to
edit a record I get an audible bell sound and nothing happens. I have other
forms that work fine in the same database. I have gone through the
properties list from both forms. What am I doing wrong? I would like to be
able to edit the record at any time the form is open.
Thank you
Glenn
 
A

Andy Hull

Hi Glenn

When you try to edit the record is a message displayed on the left of the
status bar (grey bar at the bottom)?

It sounds like the source query of the form is not updatable - look up
updatable queries in the Access help.

Depending on the structure of the query you may just need to make sure all
the tables involved have the correct primary key defined.

If you need further help post the SQL of the query.

hth

Andy Hull
 
G

glnbnz

Thanks Andy
I didn't have a primary key defined in my main table. I knew it was
something simple like that.
Thanks again
Glenn
 
Top