Drop-Down Box - Combo Box

[The Hogans]

Hello,

I have created a database and 2 of the fields are currently Combo Boxes,
however I can only select one piece of data, then in the next record if I
select the same thing it comes up with an error.

I would like to change these to Drop-Down boxes because I think this would
fix it, but whenever I selec the drop dow box icon in the toolbox, all of
access shuts down.

Please Help

 

[Arvin Meyer]

I'm not sure what you are referring to since a combo box *is* a dropdown
box. If you have used combo boxes in the table, get rid of them immediately:

http://www.mvps.org/access/lookupfields.htm

Instead write a query using both tables and use the query as the
recordsource for a form. Now you should be able to to create your combo box
in the form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access