Auto Fill Form with a requirement

[mikeybe]

Making a very simple library circulation database for a school
project.

I have a Patron Information table(patronID, first name, last name,
phone) , an item information table (bookID, book title, authorfirst,
author last) and a circulation file (ID, bookID, patronID,
checoutdate, checkindate).

Circulation file is linked to others in a one to many fashion so that
I can have the same book checked out time after time.

I'm trying to make a form so that the library worker can select a book
that is checked out from a combo box and the information pertaining to
who checked it out and when, is filled in automagically. This only get
complicated because there will be the same BookID in the circulation
file multiple times as the book is checked out and in by many people.
The only difference is that the record that I am interested in has a
null value in the checkindate (i.e. it wasn't returned yet by that
patron). So really, I want the form to have the dropdown to show only
books that are checked out (i.e. have a null value in the checkin
date), and then autoupdate that record with the current patron who has
the book, ignoring all other records that have the same BookID but
have been checked in in the past.

I made a query looking for all circulation items that had a null value
in the checkindate, which indicates that it is checked out, and that
worked. But I can't seem to make a form to autoupdate based on only
that query. In fact, I don't know how to make a form autoupdate at
all:)

I don't know VB but I have some qbasic experience:) I have been
looking at other posts and noticed lines like Me.txtAddress1 =
rstTrusts![Address1]- no idea what the Me. function is or dlookup and
stuff like that. A dummy version would be helpful where you can
explain the code a little if you feel nice. Of course, giving me the
code free solution would be helpful too:)

I know this is a lot. I appreciate any help:)

Mike

[Larry Linson]

One of the three options on the first page of a Combo Box Wizard is at the
bottom of the list: "Find a record on my form based on the value I selected
in my Combo Box". You can specify the Row Source (that is what populates the
dropdown list, and should consist of the unique ID of the record plus enough
information for the user to select) of the Combo Box to be the Query you
describe and the Record Source of your Form to be the Table or Query with
the information you want to display on the Form.

Larry Linson
Microsoft Access MVP

"mikeybe" <mi******@hotma il.com> wrote in message
news:41******** *************** ***@posting.goo gle.com...

Making a very simple library circulation database for a school
project.

I have a Patron Information table(patronID, first name, last name,
phone) , an item information table (bookID, book title, authorfirst,
author last) and a circulation file (ID, bookID, patronID,
checoutdate, checkindate).

Circulation file is linked to others in a one to many fashion so that
I can have the same book checked out time after time.

I'm trying to make a form so that the library worker can select a book
that is checked out from a combo box and the information pertaining to
who checked it out and when, is filled in automagically. This only get
complicated because there will be the same BookID in the circulation
file multiple times as the book is checked out and in by many people.
The only difference is that the record that I am interested in has a
null value in the checkindate (i.e. it wasn't returned yet by that
patron). So really, I want the form to have the dropdown to show only
books that are checked out (i.e. have a null value in the checkin
date), and then autoupdate that record with the current patron who has
the book, ignoring all other records that have the same BookID but
have been checked in in the past.

I made a query looking for all circulation items that had a null value
in the checkindate, which indicates that it is checked out, and that
worked. But I can't seem to make a form to autoupdate based on only
that query. In fact, I don't know how to make a form autoupdate at
all:)

I don't know VB but I have some qbasic experience:) I have been
looking at other posts and noticed lines like Me.txtAddress1 =
rstTrusts![Address1]- no idea what the Me. function is or dlookup and
stuff like that. A dummy version would be helpful where you can
explain the code a little if you feel nice. Of course, giving me the
code free solution would be helpful too:)

I know this is a lot. I appreciate any help:)

Mike