Form

[ACI]

I would like to create an interactive form. Where the end used can select the
fields they would like to see in the form.

 

[John W. Vinson]

I would like to create an interactive form. Where the end used can select the
fields they would like to see in the form.

That's possible but a WHOLE LOT of work. Why? What's the context? What is the
structure of your tables, and what use will the users make of this
flexibility? Do you trust your users to get into form design mode and build
their own forms?

 

[ACI]

I really don't trust my users. They are not familiar with access and could
corrupt my data. My users would like choose what info appears on the form at
the momemnt. I thought it may be best to build it off a query.

 

[John W. Vinson]

I really don't trust my users. They are not familiar with access and could
corrupt my data. My users would like choose what info appears on the form at
the momemnt. I thought it may be best to build it off a query.

Well, that just moves the problem. You could certainly use an Autoform based
on a query - but then you have to create the query somehow.

Again: context! What's the table structure? What do you want the users to be
able to choose, and what should they be compelled to include?

 

[Klatuu]

John's concern and confusion is the "why" of the question.
You mention the user's are requesting the capability. You will have to
learn that users often request a functionality without knowing what they are
really asking for.

It is actually up to you as the developer to do some analysis of the request
and determine what the user really wants to do. Often, as in this case,
they are asking for something that, in reality, make no sense and/or serves
no real need.

It is possible to show and hide controls on a form using their visibility
property so users could see only what they want to see, but again, to what
purpose?