Hi All,
I have a form (and subform) with a number of equipment IDs on it. I have another control that is a combo box and I want to show the other equip IDs that are not already on the form. So, in short, I have IDs 1-4 on the subform already and I want the combo box to only show me IDs 5 and up since 1-4 are already on the subform. In what method do I need to structure a query to return records that are not already listed?
Thanks,
Mark
Query - Select items not on form
-
- 3StarLounger
- Posts: 253
- Joined: 19 Apr 2010, 09:01
- Location: Indiana, USA
Query - Select items not on form
Thanks,
Mark
Mark
-
- Administrator
- Posts: 78528
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Query - Select items not on form
Can you tell us how the form and subform are related?
Best wishes,
Hans
Hans