how to lock a form for changes?

[kevin_vdb]

I made a table containing information about products (price, amount, supplier,...). The most inportant info is the order number (cause it's unique).
Then I made a form, containing a combo-box and several text-boxes. The idea is to find a record using the combo-box, and vieuwing the information of that product in the form. This works, but a problem occurs: the order numbers change each time in a single number (I guess the autonumber). How can I solve this problem so that my combo-box is still available for searching, but no changes can be made in the table that is the source for the form?

 

[jkl0]

In the property for all of the other textboxes set Locked = Yes

Hope this helps?

 

[ions]

I don't quite understand what is happening fully but I think your combo box (the one used for searching) is bound to a control source (second attribute int properties). You don't want that, you want it to be unbound.