RE: combo box filter source
- From: "bigwillno2 via AccessMonster.com" <u32748@uwe>
- Date: Thu, 05 Jul 2007 15:22:21 GMT
Hi Karl
what i get is:
modelNumber, prototype, and primary key for whatever i select from the combo.
e.g. i picked the first one...and it game me 1 in the third column. what
would be next?
KARL DEWEY wrote:
Test what you are getting from the combo box like this ---
SELECT MSM.ModelNumber, tblProtoType.ProtoType,
[forms]![frmPrototype]![cboPrototype]
FROM tblProtoType INNER JOIN MSM ON tblProtoType.ProtoType = MSM.ProtoTypeNum;
thanks for the quick answer Karl. Here is my SQL[quoted text clipped - 12 lines]
can somone help me please.
--
Message posted via http://www.accessmonster.com
.
- Follow-Ups:
- RE: combo box filter source
- From: bigwillno2 via AccessMonster.com
- RE: combo box filter source
- References:
- combo box filter source
- From: bigwillno2 via AccessMonster.com
- RE: combo box filter source
- From: bigwillno2 via AccessMonster.com
- combo box filter source
- Prev by Date: Re: When is a Null not a Null?
- Next by Date: Re: When is a Null not a Null?
- Previous by thread: RE: combo box filter source
- Next by thread: RE: combo box filter source
- Index(es):
Relevant Pages
|