Ok...

Simple question, but i cannot find an answer...

I have tables programs with all education programs.
I have contracts table with field programs.
And i have query based on that two and other informations.

I try to put in combobox control contracts program ID with query to table program names, but it list only contract that is used in contract before, not whole programs from that table.

What am I doing wrong?

razno,

Would it be possible to zip and attach your database?
Sometimes it is easier to offer a solution if we can see it.

Brainfade..

I used main query as row source for programs, not table with programs.

But i have another question.

In main form i have education program name, contract, application forms and so on with own tables.
I put that all together with query and based form on that.
Question is - how to make in form new record automatic put new avaiable auto id in contract id field (control source autonumber id in contract table) , and application form id and so on...

if i didnt explain clearly enough, please ask me for clarification. English is not my primary language.

razno,

To overcome the language differences, would it be possible to zip and attach your database?

Again brain fade.

I prepared to send and wrote down instruction and questions, and than discover that it work...



Sorry, Stupid me..