continuous form combo box

[spinkung]

Hi

I am trying to set the values of a combo box based on one of the values in my form data source.

my form has
lk_id (10,11,12,13)
lk_description
fa_id

i have made the fa_id a combo box to show it's description (from another table).

i want to filter the combo box based on the lk_id, so lk_id 10 will have 3 fa_id's (1,2,3), lk_id 11 will have 3 (4,5,6) etc.

problem is when i load the form the fa_id's are all lk_id 10's associated fa_id (1,2,3)?? It does not filter the combo box based on the lk_id range, it only filters based on the first/selected lk_id.

I'm hoping that made sense.

can anyone advise. thanks, spin.

 

[JamesMcS]

Have you got lk_id in the table that you get fa_id's description from?

 

[spinkung]

hi,

yes i have the lk_id in my fa_id table.

it's set up as

fa_id, fa_desc, lk_id
1, desc1, 1
2, desc2, 1
3, desc3, 1
4, descA, 2
5, descB, 2
6, descC, 2

 

[vbaInet]

It's a Continuous form, it won't work with conventional methods.

See the following link (i.e. Continuous Form Combo):

http://www.databasedevelopment.co.uk/examples.htm

 

[spinkung]

wow, took me a while to get my head around it but after looking at the link posted by vbaInet it works a treat. It's basically the Form_Current() event you have to use.

brilliant, thanks.