Latest Lists

How do i create a drop down list in Access 2007 form?

I need to have a drop down list (combo box) so that it can allow the user to select options. These are not stored as records or in any other table, so would just be a formula??

Public Comments

1. Try using Lookup from the Design View (on the column you want as a drop down). The datatype should be Lookup, then follow the prompts from there
2. A form is based on the table which is the major component of any database and you need to design your table so that you have the correct datatypes. For this particular field it needs to be a lookup data type then you will get your options. If you are not likely to change these options, as in titles, i.e. Mr, Mrs, Ms etc. then use the I will type in value option under look up but if you are likely to want to add to the list of options or change, then create a separate table for them.