how do i create a drop down menu in access 2007 form

  • Thread starter Thread starter Peggy @ TDR Electronic Recycling
  • Start date Start date
P

Peggy @ TDR Electronic Recycling

I am just learning access and have gone through all of the online training I
could find in the last 2 days. I am trying to design a workable data base
for our small e-waste recycling company. One of the things I wanted to add
would be a drop-down menu in the customer contact form labled 'Items to
Recycle'. It would include a very long list of items that we accept for
recycling, that she could chose from that would not only create a list in
that field but also add to 'Pick up request form'. Any help would be
apprciated. I will need to use this process to link several forms, and hope
that this information will allow me to do this.

Thank you,
Peggy
 
That long list of choices of items that could be recycled belongs in a
table named something like tblRecyclableItems. The mechanism of
choosing an item would likely be a combobox based on a query on that
table.

Beyond the above, I can't say because I know nothing about how you are
building your application. When it comes time to put the combobox on
your form the wizard will help you with suggestions.

Welcome to Access development!

HTH
 
Thank you for your help, it did point me in the right direction. I went and
bought the book today and hope that it will allow me to look up what I need.
 
Back
Top