Enter data
 

I need to do the following,

When the user clicks on a cell, it will lanch a small form that contains all
of the valid data for the cell, those data are from an Access database. When
close the small form, all selected data will be entered into the cell.

Is there any way I can do that? Thanks.

Enter data
 

Use Data Validation and pick the list of options from your database.
--
Gary's Student


"John" wrote:

I need to do the following,

When the user clicks on a cell, it will lanch a small form that contains all
of the valid data for the cell, those data are from an Access database. When
close the small form, all selected data will be entered into the cell.

Is there any way I can do that? Thanks.