Selecting from combobox... read only

D

Doraemon

I have a combobox on a form with a list of users. I want a user to be
able to select his/her name and then type in a password which to open
another form. The problem is that when they select their name, it's
updating the database and replacing the initial name on the start up of
the form with the name they select. How can I change it so that they
can still select their name, but it's not updating the database?
 
R

Rick Brandt

Doraemon said:
I have a combobox on a form with a list of users. I want a user to be
able to select his/her name and then type in a password which to open
another form. The problem is that when they select their name, it's
updating the database and replacing the initial name on the start up
of the form with the name they select. How can I change it so that
they can still select their name, but it's not updating the database?
Click to expand...

The Form and/or the ComboBox should not be bound (blank RecordSource for the
Form and/or blank ControlSource for the ComboBox).
 
J

John Vinson

I have a combobox on a form with a list of users. I want a user to be
able to select his/her name and then type in a password which to open
another form. The problem is that when they select their name, it's
updating the database and replacing the initial name on the start up of
the form with the name they select. How can I change it so that they
can still select their name, but it's not updating the database?
Click to expand...

Make it an Unbound combo box: view its properties in form design mode,
and blank out its Control Source property.

John W. Vinson[MVP]
 
Top