Combo Box to list previous entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a field to accept new data and to list previously
entered data to select from. Can someone please guide me in this project.
Thank you for any assistance.
 
hk,
Do you want a combo that will list all the previous values entered into the recordset
for that field, or just the "last" value entered in the previous record?
If all entries then...
Let's say your form was based on a table called tblAddresses, and you wanted to be able
to choose a City from all the Cities entered so far... or eneter a new City.
Create a combo, with a rowsource query based on that City field in tblAddresses. Make
it a Totals query so that each city previously eneterd only shows once in the list. Make
the combo LimitToList = No... that will allow you to enter a new City if it does not exist
in the list. On the next New record, that new City will also show in the combo as a
possible choice.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
I tried the totals querry by listing the field and using the sum with First
as Totals. Unfortunately, the field (from the forms view) does not list any
of the previously entered data. The field presents with a down arrow to the
extreme right but when clicked, no data is present. Any thoughts?
 
hkhella.
Don't use Sum... use Group By, and also add a criteria for Is Not Null ( so any records
with no entry in that will not cause a blank to list as a possible choice)
Also, you can run the query right from Design Grid to see what your results will be.
Previous entries... will show up as...
Boston Boston
Boston Chicago
Chicago Denver
-Null-
Denver

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Showing combo box box that's not an option in its drop-down list 5
Access - Combo Box list restrictions 1
Combo Box 1
First entry in combo 7
Requery Combo box in subform. 0
Combo Box Help 7
Stop entry data to my combo box! 13

Back
Top