Changing rowsource

[finberg]

I have a Subform Contacts wich has fields :Firm,Contact peron
I want the RowSource for the Firld Contact person to be Selected form the SoWorkers table on Firm field
Please help me to do that.
Thanks alot
Arseniy

 

[dpimental]

You will have to be more specific.

What kind of fields are they? Text Boxes, comboboxes,ect.?

What is the source of the Main Form?
What is the source of the subform?

If they are comboboxes, it is easy. You can open the form in design mode, right click the combo box, select properties, click the build button (i.e. the one with "..." next to it), and build the rowsource yourself.



David Pimental
(US, Oh)
dpimental@checkfree.com

 

[finberg]

Both fields are comboboxes
But the variant you advice doesn't work- it select the data only for the first enty you open and then uses it to all next rows.

 

[dpimental]

I'm sorry, I don't understand.

Could you clarify.

Are you wanting the 2nd combobox to be limited by the value you select in the first combobox?

David Pimental
(US, Oh)
dpimental@checkfree.com

 

[finberg]

I have tables
Firms:Number,name
CoWorkers:ID;Firm(linked to previuos table);Name

Contact_result:Code,Firm(as number,selected from the table Firms),Result
Contacts: Number, Code (linked to the parent),Contact person,Details

I made a form to work with them
in main form I am getting the values from the Contact_result table, in a subform- from the Contacts table.
Ia a subform the combofield Contact person should be selected from the CoWorkers table where firm= parent.firm (firm field is a parent form)
The problem is that if you just give the select criteria, it select the data only once and uses it for all the entries in the list
You can see the database on

http://www.utteraccess.com/forums/s...d=allposts&Main=227679&Search=true#Post227679

Thanks for your attention
Arseniy