Hello,

I have created a form (Access 97) where i have a field called Short Description, i have created another form that is opened from this main form, which displays all the short descriptions entered for a particular customer.

I would like to be able to open this description form so that the user can select a short description from the form and the corresponding record will appear on the main form.

I am using a list box on the second form to display all the short descriptions for that particular client.

Can anybody help?
thanks

On the Form_Close Event Add code similar to this:

Forms![MainForm].[ShortDescription]= Me.[ShortDescriptionCombo]