>For one of my forms I have a drop down list populated with one field of a table (which has just names of materials, and some data on them) and saves to another table (the main one for this form).Using default values for everything else except for the name, can I have a user add to this pld? Actualy it is unimportant that this data is saved in the RowSource table, just in the ControlSource since data not in the RS's table is unlikely to be reused (and would offer too many choices after a while :)
Having Combo.Style=0 you allow user to type in text portion of the combo, this will be saved in Combo.DisplayValue property and can be used to populate table.field.
Edward Pikman
Independent Consultant