472,131 Members | 1,400 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,131 software developers and data experts.

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 1403

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.