Please Help - existing data

[Lori]

I am not very experienced with access, so please help if
you can. Here is my situation. I have a
form "Companies" in that form I have a command
button "Investments". When opening the
form "Investments" it allows you to set up many
Investment Companies. The Name field pulls from another
form "Contacts". My problem is that I set up all the
Investments and instead of using the navigation button to
go to the next Investment, my staff is hitting the pull
down and selecting the Investment...thus changing the
name of that Investment. Is there anyway to set up a
list of existing Investments already set up, in the
header, which will allow for the person to select from
the list? Any suggestion, instruction is welcome. Thank
you in advance. Lori

 

[Mike]

Lori,

Use a ComboBox and set the Combox "Row Source"
to a table with the Investment categories or
you can set them up yourself.

For more help, go to MS Access HELP and
search on "Combo box".