query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to creat a query will have a drop down list that I can pick names from. And also is there a way to put a password to prevent someone from accidentally deleting of change a data already enter without using a password?

Can anyone help
 
The "syntax" of your question is a little confusing as
queries don't have dropdown boxes. Forms have dropdown
boxes.
But I'm going to answer based on what I THINK you want.

Create a table that contains all the items you want in
your dropdown box. Let's call the table "tblItems".

Create a Form and place the combobox control on the form.
Under the PROPERTIES for your combobox select:

Row Source Type: Table/Query
Row Source: tblItems
-----Original Message-----
I want to creat a query will have a drop down list that I
Click to expand...
can pick names from. And also is there a way to put a
password to prevent someone from accidentally deleting of
change a data already enter without using a password?
 
Back
Top