I'm Going Out Of My Mind

[bradwould]

Ok... I have notice that every body and their dog has asked this question and reading all the other posts has helped me along. However i have hit another roadblock. I know that IT IS possible to have a combo box that, when an item is selected, selected fields are automatically filled. Is it possible though to have those auto filled fields retained when a new record is selected in the form.??

Eg.
I have a table with model#s of a product aswell as unique properties of each model...I set up a form with a combo box to select the model# and auto fill the properties of that model into the fields below. when i change the record (record selectors <- ->) the combo box and related fields stay the same. can i make it so that each record is saved idividually and still use the autofill by combo box ....

man i dont even know if this is gonna make sence to anyone...but if it does any help would be extremly appreciated.

thank you

 

[FoFa]

If the fields in the form are BOUND to the underlying table, and you change them (by selecting something in the combobox or keying them) and move to the next record, it should save them for you. Also it should change the fields to reflect the current data in the current record. If it is not you must not be using bound fields OR I misunderstand the question.

 

[bradwould]

Thank you very much...all is well now. It was the unbound fields causing me grief. FoFa rocks!!