Selecting from combobox... read only

  • Thread starter Thread starter Doraemon
  • Start date Start date
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?
 
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).
 
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]
 
Back
Top