Combo Box On Table?

[Joe Delphi]

Hi,

I am developing an Access database for a customer who is used to
using Excel. He wants to be populate certain fields using the value from
a combo box, but he told me not to develop a form, he just wants to put the
table in DataSheet view and attach the combo boxes to the fields in that
view. He likes the DataSheet view because it appears similar to the Excel
spreadsheets with which he is used to working with.

I don't think it is possible to do this - I think that combo boxes
were made to be part of forms and not tables, but before I tell him this, I
thought I would check here to see if anyone knows of a way to attach a combo
box to a table and make it available to the user in DataSheet view.

Does anyone know if this is possible and if so, how do you do it?


JD

 

[Guest]

Yes you can do this but I warn you, most of the regulars here will caution
you not to enter data directly into a table.

You can have combo boxes on a form set to datasheet view. It works the same
as a regular form. It also looks like Excel for the users scared of change.

Tables are not designed for data entry.

 

[Guest]

Can you make the form look more like excel? Add lines and such and make him
think that?