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

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
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

glitch: opening form to specific record using its ID 2
Copy record in one form into a new pop-up form 0
Question about finding specific record on a Form linked to a table 1
Open a Form to a Specific Record 1
Duplicate record in Form and Subform 0
Go to a Specific Form 3
go to specific record based on choice in subform 2
Open form to specific record from button on continuous form 4

Top