Help with changing the content of a list box based off a selection from a combo box

[abader]

Good day everyone. I am looking for assistance in making a list box dependent on a combo boxes selection. Long story short, I have been forced, employer and client know I'm in over my head and both told me to "figure it out", to create a data base that tracks kits of equipment. Each kit has items that are expendable and items that require calibration. I have 3 tables, a kit table, subcomponent calibration table, and an expendable table. I am to create a "Request form" that allows them to select what kit they want, display the contents of that kit, and an additional List box that displays additional equipment available for selection to add to the request. I am struggling with linking the list box to the combo boxes selection. I thought that using the same set up as cascading combo boxes would work, but I haven't had any success. Any suggestions?

[Gicu]

What do you mean not having any success? Errors, not the expected results, etc.? Not much to go by but for the listbox row source property use a query that uses the combo's value in the criteria. Then requery the listbox in the after update event of the combo. How are the "additional" items from the list box linked to the selection in the combo?

Maybe you can explain a bit better and/or post a sample of your database (compact it then zip it) so we could have a look.

Cheers,

[abader]

Vlad,
The attachments on here wouldn't load the file, so here is the link to my Google Drive it is on. It wont display anything. I'm sure it is something dumb that I did, I just don't see it.

https://drive.google.com/file/d/1yJU...ew?usp=sharing

[pbaldy]

Post 3 was moderated, I'm posting to trigger email notifications.

I deleted the duplicate post.

[Missinglinq]

Is the Multi Select Property (Properties - Other - Multi Select) of the Listbox set to None?

Linq ;0)>

[Gicu]

The link doesn't work, says I need to request access. Have you compacted the Access file then zip it and you still couldn't upload it? How big is the zip file?

You should play with the query that is used as the row source for the list box until it returns the results you want then simply requery the list after you change the value in the combo (using the combo's AfterUpdate event).

Cheers,

[davegri]

How are you building the kit contents?
Do you have "standard" kits?
How many kits are there?
Do you need to save the modified kits when users request additional items?

[abader]

Vlad, I got the notification for that and approved it. I assumed it would let you in. The zip file was just over 300MB, it wouldn't load in the attachment section.

[abader]

Dave,

There are 6 standard kits right now. Each kit, all on one table, is related to two other tables. Once the kit and additional items are selected on the Request form, the client wants it to be auto-emailed to me and a co-worker of mine, which i haven't even attempted to figure out yet, I currently have it exporting the request form to PDF and saving on the desktop and the requestor needs to email it out.

[Gicu]

Sorry but it still doesn't work. Can you please start with a new file and import just the tables (and any queries based on them) and the form in question. Don't need much data, especially if you have pictures or attachments embedded in the database (300 MB zipped is a large file0 which I recommend against (should store the paths to the files not the files themselves).

Cheers,

[Gicu]

Hi Allen,
Please have a look at the updated file. I have added some code to email a PDF (new report) using Docmd.SendObject to a certain email (you can enter more than one, just separate them using a semi-colon) stored in a new table tblSettings.

I have removed the two big tables so I could upload it here, just import them from your original db. I recommend you abandon the "attachement" fields and use short text to store the paths to the images instead. Loading so many pictures into the db will very soon get you to the 2GB limit for Access.

Cheers,
Vlad

[davegri]

Siemens Database-davegri-v01.zip
See if this helps. It doesn't address all your issues, but should help with original problem. Sorry I had to remove the DB attachments to reduce size to make it uploadable.

This form lets you define the standard Kit contents



Then this form lets you create a custom kit based on a standard kit.