i cannot edit the table using the forms???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

reservedbcreater - 27 Jan 2005 21:15 GMT

i can use the forms to populate the table.
but if i need to fix something it doesnt update.

i have the forms set so that i can only see a new record(so that then u
scroll the mouse it doesnt go through ur records it just shows a new blank
record)

but when i enter in on a blank form a ID number that has previously been
entered and i fill out the rest of the form and save, it doesnt save
overtop of the first record using the same ID.

i want it to overwrite, ie enable editing without having the mouse be able
to scroll through all the records

Reply to this Message

Rick B - 27 Jan 2005 21:22 GMT

You can't.

If you want to edit a previous record, turn off the "data entry" property of
the form, find the record to edit, and make your changes.

You can't simply type a revised record and expect Access to know that you
want it to go find one where one of the fields matches and then replace it
with your new record.

Rick B

> i can use the forms to populate the table.
> but if i need to fix something it doesnt update.
[quoted text clipped - 9 lines]
> i want it to overwrite, ie enable editing without having the mouse be able
> to scroll through all the records

Reply to this Message

reservedbcreater - 27 Jan 2005 21:44 GMT

if i made a seperate form the exact same design bound to the same controls,
but set data entry property off and use it for editing only????

Reply to this Message

Rick B - 27 Jan 2005 21:49 GMT

Sure. That would work.

Basically, have a data entry form and a data revision form.

> if i made a seperate form the exact same design bound to the same controls,
> but set data entry property off and use it for editing only????

Reply to this Message

John Vinson - 28 Jan 2005 06:38 GMT

>if i made a seperate form the exact same design bound to the same controls,
>but set data entry property off and use it for editing only????

There are a couple of alternatives. I don't much like the Data Entry
property for just this reason!

One choice would be to put the following code in the Form's Load
event:

Private Sub Form_Load()
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
End Sub

This will default to putting you into the new record when you open the
form, but allow you to go back if you wish.

Or, you can put code in a Command button to set or clear the form's
Data Entry property.

John W. Vinson[MVP]

Reply to this Message

Rick Brandt - 28 Jan 2005 13:43 GMT

> if i made a seperate form the exact same design bound to the same
> controls, but set data entry property off and use it for editing
> only????

Nothing that drastic is needed. DataEntry mode is nothing more than the
application of a filter that returns zero records. All you have to do is
"Remove All Filters" and all records are then available in the form.

Better idea on larger tables though is to provide an easy way to filter the
form to the desired set (preferably a very small set) of records. The form
can then open by default in DataEntry mode, but the filter methods allow
them to easily look at any other record they need.

Particularly when used over a network it is important to always load as few
records as possible at any one time.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message