Forms

S

SS

Hi

I have a form which updates the database based on the ID. This has to be
filled in by users depending on the ID I send them to approve.

The problem is that the ID keeps changing therefore if they don't action
immediately they may have to go back an ID or two to get to the ID they
should approve.

Is there a way to either create a form where they put in the ID and the
information comes up with the information and then they can alter this and
submit it?

Hope that is clear!

Thanks Shona
 
S

Stefan B Rusynko

Sounds like you need to rethink your DB / form design to make the DB field "ID" unique & unchanging




| Hi
|
| I have a form which updates the database based on the ID. This has to be
| filled in by users depending on the ID I send them to approve.
|
| The problem is that the ID keeps changing therefore if they don't action
| immediately they may have to go back an ID or two to get to the ID they
| should approve.
|
| Is there a way to either create a form where they put in the ID and the
| information comes up with the information and then they can alter this and
| submit it?
|
| Hope that is clear!
|
| Thanks Shona
|
|
 
A

Andrew Murray

"ID" is the primary key default field (auto number) that is created if you
create the DB (access) through frontpage based on fieldnames in your form.
With the Database results wizard, ID won't actually be a field from your
form, frontpage creates this field as an autonumber and makes it the Primary
Key..

You'll need to name the ID field you're asking about as something else so
they don't conflict.

Alternatively you can change that field in MS Access and make "ID" a text
field (rather than "auto number" as Access calls it), mark it as the
Primary Key (which has to be a unique value to each field such as an id
number like in your case).
 
Top