I need to know if there is a way to let the user decide which fields they want to show up on a form. For example: When entering inventory each user probably has different information needs and may wish to specify which fields they need and also which order they should appear in. They may or may not need fields such as "item number", "description", "pattern", "color", "size".
I know this can be done, and I have some ideas but I'm not sure about syntax or whether or not this can be done by a series of queries or by creating a recordset in code. Any ideas?
I know this can be done, and I have some ideas but I'm not sure about syntax or whether or not this can be done by a series of queries or by creating a recordset in code. Any ideas?