how do I display selected fields from one subform in another?

[Guest]

Hi
I have a library database. It has a function that filters all items by
topic and displays items corresponding to each topic in a subform datasheet.
I want to create a way of 'checking out' an item. I was thinking that I cold
make it so that you clicked on the particular record/item from the subform
that you wanted to borrow and then go to some sort of checkout. This
checkout form would have a couple of fields from the above subform to link it
as well as some more (I am hoping that I will in the future be able to run
reports to show how often each item was borrowed). However, I can't make
this new checkout form link in with the subform and display the record
selected. How do I fix this or is there a simpler way to do the whole
checkout thing?

Thanks, Jo

 

[Joseph Meehan]

Hi
I have a library database. It has a function that filters all items
by topic and displays items corresponding to each topic in a subform
datasheet. I want to create a way of 'checking out' an item. I was
thinking that I cold make it so that you clicked on the particular
record/item from the subform that you wanted to borrow and then go to
some sort of checkout. This checkout form would have a couple of
fields from the above subform to link it as well as some more (I am
hoping that I will in the future be able to run reports to show how
often each item was borrowed). However, I can't make this new
checkout form link in with the subform and display the record
selected. How do I fix this or is there a simpler way to do the
whole checkout thing?

Thanks, Jo

Could you start by telling us how your data is stored?

How many tables and how are the tables related?

 

[Guest]

It is a very simple database and the data at the moment comes from just one
table.

 

[Joseph Meehan]

It is a very simple database and the data at the moment comes from
just one table.

Good. Next questions. Do you want to keep a history of checkouts, or
just keep the current one, deleting that data when it is returned.

Are you recording return and changing the book's status?

What information might you be capturing when it is checked out?

 

[Guest]

Hi
thanks for replying...
In answer to your questions:
Yes I would like to keep a history of checkouts
Yes I would like to record return/status of book
I would like to capture info such as the persons name who has borrowed the
book and/or which office team they belong to.

Jo

 

[Joseph Meehan]

Hi
thanks for replying...
In answer to your questions:
Yes I would like to keep a history of checkouts
Yes I would like to record return/status of book
I would like to capture info such as the persons name who has
borrowed the book and/or which office team they belong to.

Jo

Check out:

http://office.microsoft.com/en-us/templates/TC102068831033.aspx

See if you get any ideas there.

 

[Guest]

Thanks for the suggestion joseph. I had already come accross this template
but unfortunately can't download it as I am working off access 2003 (at work
so I can't really download the free trial version of office 2007 either) and
it's apparrently not compatable. Any other ideas?

 

[Joseph Meehan]

Thanks for the suggestion joseph. I had already come accross this
template but unfortunately can't download it as I am working off
access 2003 (at work so I can't really download the free trial
version of office 2007 either) and it's apparrently not compatable.
Any other ideas?

Sorry That is the only one I found also. I would think there are lots
of others but I don't see any.