I am building an update form.
The MS Access Table has 2 columns
id - autonumber, unique, primary
field1 - text
Using the insert update form dialog everything seems ok but I get this message:
"... choise a unique key ... "
BUT I already have. Why is this message coming up?


Steven Levy, 781-771-2779,

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Using the insert update form...
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Are you inserting or updating records?
To update you need to filter data with unique key.

I am updating records. I have used a filter. It seems to accept a non-unique column which is strange.

Steven Levy, 781-771-2779,

The recordset that your using to update the record with, have you selected selected (eh?!?!) in the recordset dialog.

What I'm trying to say is in the recordset only select the column you are trying to update (not the all radio button), as if you try to update the unique column it won't work.

www.k.abbott.btinternet.co.uk/

To create an update form I do the following:
1 - create record set
2 - insert update form - include unique id column.
3 - change column to hidden
4 - fix query string to remove reference to id.
Is this a bug - or am I doing something wrong.


Steven Levy,

How are you removing the reference to the unique ID?

Are you doing this manually because this might be your problem.

When creating the recordset that your using to update the record with, choose only the column that you are updating. So select the selected radio button from the recordset dialog.

www.k.abbott.btinternet.co.uk/