I have several forms linked tables via queries. The form pull data such as sales and ratios by selecting a product from the main's form's combo box.

I am however having to issues:

1- I would ultimately prefer the combo box to be a free entry; however by just entering in the box and hitting enter (not a button called “enter on a screen” which would initiate recalcs, just normal enter), while it does bring the new information in sub-forms it also changes the information in the original table. If I make the table read only that it just doesn't allow the form to work by saying that the table is read only.

2- The same Read only issue occurs when another user with read only rights tries to use the database.

I understand that ready only is functioning as intended, however I am wondering if there is way to make some functions work while disallowing the updating.

I am unfortunately learning on the go, so go easy plz.

Thank you