Displaying dynamic table in datasheet view

[Guest]

Hello all:

I've written an application that allows users to build a table through a
form interface. They enter in a descriptive field name (i.e. Number of
Employees, Years in Business), and thru vba, I dynamically create the actual
field name (i.e. field1, field2) and map the actual field name to the
descriptive field name in a separate table. So the actual table looks like:

field1
field2

The table containing the mappings looks like this:

field1 Number of Employees
field2 Years in Business

They want to be able to enter data into this table through a "datasheet
view" type of system so entry is quicker. But if you open this table in
datasheet view, the user would not know what field name they actually want to
edit since the descriptive names they gave when setting up the table are in a
different table. Make sense?

Anyway, I'm looking for some advice, suggestions and how to pull this off in
some way. There are not a fixed number of fields in these dynamically built
tables so I can't build a static form (using continuous forms) that would do
the trick. Looking for any creative solutions.

Thanks.

 

[John Vinson]

They want to be able to enter data into this table through a "datasheet
view" type of system so entry is quicker. But if you open this table in
datasheet view, the user would not know what field name they actually want to
edit since the descriptive names they gave when setting up the table are in a
different table. Make sense?

I'd be really leery of doing this but it's your project!

I'd suggest setting the Caption property of the field. That's what
will show in the datasheet view (not the fieldname).

John W. Vinson[MVP]