Stop update in form fields (1 Viewer)

[ckhatch]

I have a form that changes data in fields when a combo box data changes the combo box is using the primary key as its data source
Question: How do I stop certain fields from getting updated when I change the data in the combo box

 

[DALeffler]

Use unbound controls on the form, setting the SQL statement for the unbound controls via the rowsource property. Then the control is only requeried by VBA code (like in the after update event of the bound combobox or a Cmndbttn_Click() event).

Doug.

[This message has been edited by DALeffler (edited 05-20-2001).]