Creating a drop down menu??

J

J. Kelley

I am trying to create a drop down menu on my entry form but when I do, it
changes the field in all records. How do I make it so that they can be
different on each record?
 
J

Jeanette Cunningham

The drop down needs to be unbound - that means that its control source must
be empty.
Select the drop down by clicking on it
On the properties dialog, on the data tab, delete whatever is in the control
source.

Jeanette Cunningham
 
J

J. Kelley

The control source is empty and the field says "unbound" in design view. I
have tried creating combo boxes and drop down boxes, I have tried linking
them to a table and typing the fields on my own and I can get the information
in there, but it needs to be restricted to the current record only.
 
J

Jeanette Cunningham

J,
it would help if you explained your set up in more detail.
Are you trying to use the combo to search for a record and show that record
in the form?
Is the form a subform on another form?
Are there any subforms?
After you find the matching record, do you want to edit in the same form or
are you opening another form for editing record purposes?
Is the form based on a query that contains all the necessary fields for the
form?
What are the allow edits and data entry properties for the form?

Jeanette Cunningham
 
J

J. Kelley

We use Access as our main database. When someone places an order, we input
thier information and so forth into the form. There are many places on this
form that currently use drop down menus or combo boxes such as the part
number, customer name, order status.... I am trying to make the payment
method a drop down box as well. This is a list that will never change so I
don't need to be able to update the list or anything, just make it to where
it doesnt change the information on evey single record.

I hope this answers your questions. I have no idea what kind of form or
subform and stuff it is. The guy who use to do this just retired and i'm
stuck trying to figure out how to fix it.

Thanks
 
Top