Query - Select items not on form

santosm
3StarLounger
Posts: 253
Joined: 19 Apr 2010, 09:01
Location: Indiana, USA

Query - Select items not on form

Post by santosm »

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
Thanks,
Mark

User avatar
HansV
Administrator
Posts: 78528
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Query - Select items not on form

Post by HansV »

Can you tell us how the form and subform are related?
Best wishes,
Hans