I created a list box on a blank form bound to a field in table. In this list box are values that I select so as to enter into a field. I then created a command button that is on a field on another form which opens this form on which there is a list box. I then added the DoCmd.Close.... statement to the click event of the command button so as to close the form upon selecting a value from the list. When I open the list box and click any one value, this value is entered in the field both on the form and the table. so far so good.
But now I would want a situation whereby I can select the value in the list box, but only enter the value in the field upon clicking a command button on the form with the list box and I would also want a method of adding new values to the list or deleting certain values in the list box while it is still open.
Thank you.
Gots