Hi everyone!

Have one trouble with form's combobox source.
I have two comboboxes linked. One - is "objekt" and another one is "klient" which uses "objekt" value.
On one form they are working correctly, on another - not.
in attached file you can check Forms - kutsed - here no problem and kutsed_test - here it asks for Forms!kutsed_test!obj_koodFK value on opening form.

Trouble is that second form includes other subforms as tabs. Thats the only difference i have found so far, but I can not get rid of them (((

Can anyone suggest on how to correct this?

It may be because your using a lookup at table level for the source of this combo..

I would create a lookup table and then link the two tables..

The Evils of Lookup Fields in Tables

HTH's

tnx for welcoming )

trouble is actually both forms are using 3 tables in background

Objektid - list of objects
kontaktid - list of persons
objekt_kontakt - a cross for both (connecting objects & persons)

so i would say it is already a lookup table, or not?

trouble is - i managed to get this working with Form - kutsed_test (if I change an objekt combo, i will be limited in kontakt - to list of persons connected to this object)

but when I tried to add tab with another form (as subform) - mistake (( asks for obj_koodFK (which is an ID for object) value all the time