469,167 Members | 1,984 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Select unused records in a listbox

Hello all!

Thanks everyone for the great help you've given me so far on this forum - I have another intermediate question.

I currently have a form where a user chooses a piece of equipment, followed by a subform where they can add records to it which are different parts that piece of equipment can have, which is working good! The user just clicks a drop down, selects the compartment they want to add and they

My tables go tblEquipment (equipmentID and equipmentName) - tblCompartment (equipmentID and compartmentCode) -tblCompartmentList (compartmentCode and compartmentDescription)

My current rowsource for the dropdown box in my sub form is "SELECT tblCompartmentList.compartmentCode, tblCompartmentList.compartmentName
FROM tblCompartmentList;" and its Control Source is set to dump their selection into the compartment table.

My Question:
I only want compartments that have NOT yet been added to that specific equipment to show up in that drop down box, so that if the user say adds a transmission, then adds another record, transmission will not be an available selection.

Thanks in advance. Hopefully I have provided enough information but please let me know if you need anything else!
Nov 12 '09 #1
0 1330

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Matthew Wells | last post: by
4 posts views Thread by Vincent | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.