ComboBox Help

[Minty]

I have adjusted the form to do what your need. When you set it up you added the materials table as part of the forms data source, this was wrong. You are only using the materials table as a look up for the combo boxes, you don't need it as part of the underlying data on this form, and in fact it would prevent you from easily adding records.

Hopefully this simple example will show you what is required to use the combo boxes.

 

[snirben]

I have adjusted the form to do what your need. When you set it up you added the materials table as part of the forms data source, this was wrong. You are only using the materials table as a look up for the combo boxes, you don't need it as part of the underlying data on this form, and in fact it would prevent you from easily adding records.

Hopefully this simple example will show you what is required to use the combo boxes.

still not working good,
when i choose materials its changeing everything,
and the subtype is allways the same,

 

[Minty]

It will be on a continuous bound form as the control is unbound. That field is not available in that table so you can't store it, you are only viewing it / using it for data entry.

You are (correctly) only storing the Material ID - you are just simplifying the way the user picks the value. Normally you would do this on a single view form where it works as expected. I would use a locked sub form to display the data below and a single main form for data entry above.