Listbox help

[ScrmingWhisprs]

I am developing a database for my work to keep track of volunteers we get for community service hours. I have the following tables:

tblVolunteers
VolunteerID (PK)
FirstName
LastName
Address
City
State
Zip
Phone
DateAdded
Notes

tblFiles
FileID (PK)
VolunteerID (FK)
OpenDate
HoursRequired
DueDate
Status
Notes

tblProjects
ProjectID (PK)
Description
Instructions
Status
Priority
DueDate
DateAdded
Notes

tblTransactions
TransactionID (PK)
FileID (FK)
ProjectID (FK)
TransactionDate
TimeIn
TimeOut
StaffInitials
Notes

I have a form where a staff person searches for the volunteer they will be signing in. A listbox displays all the volunteers in the system. They select a name, then click open, and the sign-in form opens to that volunteer. Right now the only thing on the form is the volunteer contact info. I would like to put a listbox next to it that will show all the Files for that volunteer. What I then want to be able to do is click on that file and have a subform show all the transactions (Date, Time In, Time Out, etc…). I’m just not sure how to write the rowsource for the listbox.

Please if you have any questions if I did not clarify myself, please ask!

Thanks ahead of time!
ScrmingWhisprs

 

[Melaz29]

Use a Query

Create a query that lists all files and in the criteria for volunteer ID

Like[Forms]![yourformname]![volunteerID]

Then use the subform wizard to create a subform based on the above query.

 

[ScrmingWhisprs]

That works great! Thank you!


Next issue....

I have an "Open New File" button below that listbox that will open a form in Data Entry mode to open a new file for that volunteer. How do I automatically get that volunteer ID number into that field without having to typing it in manually?


ScrmingWhisprs