As title really,
I have a Access database i have been asked to modify and need to change part of it from a question to a combo box.
Basics behind it are
Current setup
Press button on front screen
Enter Peramiter Value – Which Name ?
Enter Peramiter Value – Which Location?
Brings up report for person X at location Y
Downfall of this is that if someone types in the name wrong or in a different format i.e D Hill, Dave Hill, DHILL etc all the information for that person is not collated into the report.
I want to change it so that the first question box of Which Name? is replaced by a drop down menu of names so that they will all be entered in the same format.
Can someone tell me how to do this? I don’t really know much about Access and did not design the database, i have just been given the task of modifying it as “I’m young so should know about computers”.
Cheers
Rusty