|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
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.