query

S

sam

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
 
C

Cynthia

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
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top