In MS Access is there a way to allow forms to update while maintaning Read Only -
I have several forms of linking tables through questions by selecting a product from the main form combo box And draws data such as data.
I still have problems:
1- I would prefer the combo box for a free entry at the end; However, entering the box and entering the entry (there is no button called "insert on a screen", which will initiate the recess, only the normal will be recorded), while it brings new information to the sub-form, Also changes the table. If I read the table only then it does not allow me to work by saying that the table is for reading only.
2- The same problem reads only when another user tries to use the database only to read
I understand I am only working for the purpose of preparing, although I am thinking that some functions are a way of working while allowing updating.
I am learning on a journey unfortunately, so go easy plz
thank you
You need to link your combo box to the underlying data, but after the data has changed, set / reset the value of the combo box. In this way, if some sort of a new value is a) This data will not update or not, whether it is updateable or not.
B) You can still update the subfomes based on this value
private sub form (cmbMyDisplayOnlyComboBox = Me! WhatEverFieldHasTheValue End Sub
Again, the cmbMyDisplayOnlyComboBox control source is empty. Use the field that 'use' can be in the form of a control source, such as the EverFields
Comments
Post a Comment