RE: combo box filter source

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Re: Prototype/inFamous sales numbers (Lund)
    ... is pretty much across the board considered a much better game right.... ... Prototype to be this amazing game that blew it out of the water ... articles about the sales of Prototype and the amount of tweets ... Fallon just doesn't click. ...
    (alt.games.video.xbox)
  • Re: Prototype Funhouse-interest?
    ... tell me before I trade it for TAF ... Christopher Hutchins wrote: ... very nice LS topcoat sample game. ... SAMPLE not a prototype and it is. ...
    (rec.games.pinball)
  • Re: Prototype Anyone?
    ... judging by the start of the game appears like ... The vidzone full screen is poor quality 4:3...in ... Prototype the disguise dial is L1? ... Prototype - LB for senses, RB for disguises - I only see half a wheel, its ...
    (uk.games.video.misc)
  • Re: Prototype/inFamous sales numbers (Lund)
    ... is pretty much across the board considered a much better game right... ... Prototype to be this amazing game that blew it out of the water ... articles about the sales of Prototype and the amount of tweets ... Jimmy Fallon was horrible to watch him bomb night after night, ...
    (alt.games.video.xbox)
  • FS: Several Pins in NC or available at Expo
    ... HUO Addams Family Gold #999 - I can't verify it is HUO, ... capable of cleaning up a routed game to look like this. ... Also have spare menagerie and backbox balls in all available colors, ... true prototype Earthshaker ...
    (rec.games.pinball)