Data Entry Form with List Box
I would like to create a simple data entry form for entering new data, in addtion there's a list box to view and edit existing data in the table.
Table: tblRefDefects (DefectID, DefectDesc)
Entry Field: DefectDesc
List Box: lstDefects.
When the form opens I'd like the DefectDesc field to be blank and the List Box populted with the existing data in tblRefDefects (just the descriptions).
When a new DefectDesc is entered, it's added to the List Box. Double click on a List Box item, it becomes active in the DefectDesc field (for editing).
A method to delete would be nice, too.
Seems simple, but I'm stumped.
Thanks to anyone who has a solution.