View Single Post
Old March 12th, 2013, 01:08 AM
Jeff Monroe Jeff Monroe is offline
First recorded activity by OfficeFrustration: May 2006
Location: San Diego, CA
Posts: 27
Default 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.

Form: frmDefectEntry
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.