Hello everybody. I'm new to this forum however I have used others and I am stuck. I have some coding experience and do really well with hands on learning or reviewing what others have coded that will work with what I am trying to do. However, I did that and I'm still not getting what I need.
I am doing a somewhat basic database for my mom's church. They do work with prisons all over the states by mentoring to the prisoners and she asked me to convert the Excel spreadsheets that they use (and take forever to do) to a database. I have 4 main tables that I want to pull information in from - Inmates, Mentors, Prisons & Inmate Verification.
I am trying to do the cascading boxes for the Inmates Verifications that need to be done. So based on the State the prison is in and based on the type of prison (Federal, State, County) I want to eventually bring in the website hyperlink so the users can just click on that to do their verification. I could also match on the Prison name but will still need Prison Type and County to be part of the requirement.
I found one post on this site that I copied exactly (using my tables and fields) but all I get is a blank drop down box and I don't know what I'm doing wrong (probably missing a comma or something ).
So what I want is, when the user selects the prison it populates the address. Next they will select if it is a Federal, State or County prison/jail and based on that selection and the State in the address I need County to populate with the data that is associated (and yes county can be blank if State is selected - it is like that in the table). When they continue they will then need to select the Name of the office that the verification came from (example: Maricopa County Sheriff Office) which will then populate the hyperlink (in the final field) that they will select to do the actual verification. I stuck at County.
Right now my Combo box RowSource is:
Code:
SELECT [Prison Info].[County] FROM [Prison Info] WHERE (((Prison Info.Type}=Forms!Inmates!Type) AND ((Prison Info.State)=Forms!Inmates!State))) GROUP BY [Prison Info].[County]
also attach is the database that I am working on. Any help somebody can give me will be greatly appreciated. I know I can make it really simple for the users but I do want to this to give them some time back and not take 8 hours to do what they do - as volunteers.
Here is a screen shot of the form with the cascading fields highlighted
Mentor Database.zip
Again, thank you for any help you can give me. It's been a while since I've had to work with access.