Dec 11 2008, 04:08 AM
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?
Dec 11 2008, 04:19 AM
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
Dec 11 2008, 07:22 AM
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