OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Using Forms (http://www.officefrustration.com/forumdisplay.php?f=24)
-   -   Data Entry Form with List Box (http://www.officefrustration.com/showthread.php?t=1126330)

Jeff Monroe March 12th, 2013 01:08 AM

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.

Jeff


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
OfficeFrustration.com