Opening a form to a specific Record based on a field in the form

  • Thread starter Thread starter angelinarose
  • Start date Start date
A

angelinarose

Hi all, I need some help with some coding.
I have a database that containes about 25,000 records. Right now I have a
form that opens to shows the records, some fields already have information
contained in it. Other fields the users will have to update the form/table
with additional information. The users have to take "ownership" of the Record
by providing their ID, Name(this populates based on their ID number using
Dlookup), and ownership date. When they open the form I want it to open to
the first record that currently does not have an owner. Currently the form
opens to the first record of the table. I'm perfectly fine to have a seperate
form that does what I need it to and then another form that contains all the
records. Is there anyway to do this?
anyhelp would be greatly appreciated
thanks!
angelinarose - a newbie to Access Monster and access
 
One issue jumps out at me: is this to be a multi-user application? If so,
what stops that "first unowned" record from appearing for more than one
person?
 
Back
Top