combo box src query

[bpaquette]

so i'm addressing a problem ive been working on for a month or so, here goes:

i have 2 cbo's on my form, one of which has a list of values:


a
b
c
d
e
f



The second box is a list of possible suffixes for each possible value in box 1. so we'll say its 1, 2, 3, 4, 5

if a can only hae 1, 3, and 5 as suffix, and b can only have 2, 4, 5, so on and so forth, i need to populate list two with a query filtering out only instances where the value is true....lemme example:


the query looks something like this

a 1
a 3
a 5
b 2
b 4
b 5


so my query criteria under column one reads

[Forms]![frmPersonnel]![cboOfficerPAFSC]


I think i'm on the right track. i've been trying to emulate a sample code ancientone pumped out for me a month or two ago, but i'm afraid i can't adapt it to my needs quite right while still maintaining functionality.


if i'm being clear in what i'm trying to do, can anyone help?

 

[namliam]

if i'm being clear in what i'm trying to do, can anyone help?

Maybe you should start emailing me direct

Your query should use your first combo as a restriction, but you already have that i think....

In you after update of the first combo box you then must requery the second.

Thats all.

Regards

 

[bpaquette]

Oh come on nam, you have to let me beat around the bush and pretend i dont know you're going to help me out first, otherwise i'm imposing!

I'm afraid i dont entirely uderstand the term restriction? you mean criteria? yeah in the query that sources the combo boxes i do have the criteria as the value of cbo 1.

as far as the requerying whats syntax on that? if i unload the record and reload it, the cbo2 is still screwed up. For some reason what happens, both when i load the query up and provide a value (a for example), and when i select a in cbo1, cbo2 populates with ALL the values in it, not filtering for a dang thing. When i load the query it lists all the values in column 2, but instead of the values in column 1, it lists the provided value over and over.

i have no experience with anything beyond simple queries so the answer could be obvious, but its beyond me. i tried running the criteria right in the source query on the form, and that made things a little funny as well.

so how bout it? any ideas where i'm going wrong?

 

[namliam]

Try attached sample

 

[bpaquette]

Ahh fantastic. Took me a while to work out all the kinks while integrating but now it works exactly like i need.


maybe you should consider joining the us military nam we could use efficient guys like you!

 

[Mile-O]

maybe you should consider joining the us military nam we could use efficient guys like you!

Do you enjoying picking on cissies and showering with other men?
You do?
Join the army.

 

[namliam]

I wouldnt like having to fight in Iraque...

Thanx for the invite tho (and the complement), maybe you can send a message to my company telling them how 'good' i really am so they might finaly give me that raise...

Regards

 

[bpaquette]

the showering with other men isn't so bad...


i mean, um, er, uh, no! its horrible!



just kidding.


i'm in the air force its club med compared to the army!

i'd be glad to, nam, if i wasn't positive it would result in simply me getting laugehd at

 

[Mile-O]

send a message to my company telling them how 'good' i really am so they might finaly give me that raise...

Do some work instead of coming on the forum and demonstrate your worth that way; that's what I do!

 

[namliam]

Thats just the problem...

They have work for me but ... they tell me to do it inside of 2 weeks and am finished by the end of the day.... which leaves me with nothing but the forum... (which is good for some other ppl, but sucks for me)

Regards

 

[bpaquette]

i used to work at a company like that. the problem is if you make them realise your efficiency, then they take advantage of it maybe some freelance DB design on the side oncompany time?

 

[namliam]

Know anybody --willing to pay-- that would need anything like that?

Regards