Other SoftwarePost questions here about stuff not directly related to a specific OS (Applications, Games).
Mission Statement
WindowsBBS is an online community dedicated to easily accessible technical support for those using Microsoft operating systems and other Windows software.
Our goal is to become the leading resource for computer users that require assistance with their day-to-day computer usage, including full support for networking PC's, virus & malware removal, system upgrades and general support questions.
1. How to I make a pull-down list which dynamically reads its option fields from a table?
For example, I might have a form with a pull down list of options for "How did you hear about us?" (word of mouth / newspaper / TV advert / etc). The "options" should not be set in concrete. Rather, they should be listed as a table somewhere. This way, if I add "radio advertisement" to the table... hey presto! t appears as an option on the pull down list.
2. How do I get autonumbers (e.g. client_ID) to reset after deleting all fields, so I can start afresh?
For example, I might spent a lot of time getting the forms sorted on a database. During the process, I would have made several "fake" records / forms in order to test my data. Now that I'm satisfied, I want to delete all fields and have the client_ID auto-number restart at 0 (zero). Instead, it starts at a larger number, in respect of the previous data entry (still thinks it's up to record 207).
P.S: I'm using Access from Office 2000 on Win-98 SE
Last edited by Lancer; 6th November 2002 at 10:53.
Didn't find the information you thought to find? Check out these Similar Threads
1.) You have partially answered your own question.
Create a table containing 2 fields: autonumber and your how did you hear about us choices.
Then create your table that contains fields for all the other data you collect. Create a field for the choice in design view and choose lookup wizard.
Follow the steps and you will easily be able to do what you want.
2.) You can't. Well actually you can, but you have to delete the autonumber field and then recreate it. There are a couple of other ways to do it , but I thinks thats the easiest.
