Re: Edit Current Record Only

Tech-Archive recommends: Speed Up your PC by fixing your registry

Tim

If you want a form to only display a single record for editing, you have to
tell Access which record. If you tell Access the form can see ALL the
records in the table, then you will be able to see (and edit) ALL the
records.

If you use a query to "fill" the form, you can specify in the query that it
only returns the record you wish to see/edit. You do this by using the
Selection Criterion.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Tim" <Tim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F6E22EE2-ECAE-49C5-AF8E-C47B5EEF24E4@xxxxxxxxxxxxxxxx
Hello,
I have a DB that contains 18 forms. The user populates one form at a time
and clicks a continue button at the bottom to move to the next form. I
have
a query running when they click the next button that pulls the Branch #
and
Date and populates the next Form. All that seems to works fine, except
that
it gives the user the option to add and edit other records beside the one
they are adding. With the way the mouse wheel scrolls through records, I
can
see the wrong records being edited.

I tried setting the Data Entry to YES, but this bypasses the last record
that has the Branch # and Date from the query that ran and only shows a
blank
form. I am using the acLast command to jump to the last record on each
form.

Is there a way to go to the last record and lock out all pervious records
and the option to add records?

Thanks.



.

Quantcast