i cannot edit the table using the forms???

  • Thread starter Thread starter reservedbcreater
  • Start date Start date
R

reservedbcreater

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
 
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
 
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????
 
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????
Click to expand...

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]
 
reservedbcreater said:
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????
Click to expand...

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.
 
Back
Top