Dynamic Forms
Dynamic Forms
(OP)
I have two databases, one resides on a network and contains the live data, the second will be stored on a users computer and has a live link to the network database. The second database contains queries, forms and macros that the user will use to search/edit/remove records.
However, the live database may have fields added/removed, which may cause some havoc to the queries and forms written in the linked database.
How can I create a dynamic form and/or queries to update when a field is removed or added to the live database? This seems like a highly difficult task....
Todd
However, the live database may have fields added/removed, which may cause some havoc to the queries and forms written in the linked database.
How can I create a dynamic form and/or queries to update when a field is removed or added to the live database? This seems like a highly difficult task....
Todd
RE: Dynamic Forms
That's the simple answer. However, you mention fields being removed/added; do you mean that the actual table structure will changed?
If so, I don't know any easy way to create forms that will adapt to a changing table environment.
Larry De Laruelle
larry1de@yahoo.com
RE: Dynamic Forms
Todd