Filter field in subform from a combox in form!

[sashless]

Hello, i'm new to your forum, i'm reading it a lot, i you gave me a lot of advices, but this, i can't to it on my own, i try it but it doesn't go thrue




I want to chose field in main form (Ime in priimek), and add afterupdate code, that will filter the field Ime Priimek in subform, so that i would see just records from one person(ime priimek).


Can who help me with it?

Link to my database





LIKE THIS:




Tnx, Saso

[June7]

Sounds like dependent comboboxes. http://datapigtechnologies.com/flash...combobox2.html

[sashless]

No, Ime in Priimek combobox is in main form, and in the subform is the table "podatki" where are saving all records from main form.

[June7]

You have two forms bound to the same data. I think I know what you are attempting but this is not way to do it. You don't need form/subform for this and certainly not two forms bound to same data.

Comboboxes used to enter filter criteria should not be bound to fields. If they are entry will change the value in record.

Here is one method to use unbound comboboxes to filter a form http://datapigtechnologies.com/flash...tomfilter.html

Why does Podatki1 form open with a parameter prompt for ID?

[sashless]

I was trying to do, but, it's not working, it goes on new record everytime i chose field in combobox.



Here you go the picture.


MY TABLES:

AKTIVNOSTI
IDaktivnosti
Aktivnost

ODDELKI
IDoddelki
Oddelek

Oseba
IDoseba
ImePriimek


Podatki
IDpodatki
ImePriimek
Aktivnost
Datum vnosa
Porabljen čas

[June7]

Did you change to a single form structure? Did you unbind the comboboxes? You revised code? Post for analysis.

I don't read what ever language that is so no idea what this database is for.

Did not answer question about the ID prompt.