Build a DYnamic Continuous Form

[Rawb]

I have a Table:

Config

ConfigName	ConfigValue	ConfigType
DefaultQPPrune	180	Integer
DefaultQPSize	8	Integer
ShowQP	True	Boolean

Where the ConfigType Field can be any of the following values:

• 1 - Boolean
• 2 - Date
• 3 - Double (decimal, double, single, and currency)
• 4 - Integer (integer and long)
• 5 - String

I'm trying to make a Continuous Form that, depending on the value of the ConfigType Field, dynamically choose to display ConfigValue in a Check Box/Combo Box (for ConfigType 1) or a Text Box (for ConfigTypes 2-5) with the Date Picker (ConfigType 2 only).



Is this possible?

[June7]

I suppose could use code to set ControlSource property and visibility of each control. But be aware the setting will apply to all instances of the controls for all displayed records. I suspect the checkbox will have an issue if the data is not -1/0 (True/False, Yes/No).

[Rawb]

Yeah, that's the problem I'm running into right now. I can easily change the Control on the Form, but it changes it for every Record and not just the current one.

I was thinking there might be a way to use the AbsolutePosition Property of the Form's Recordset (or maybe a Clone of it) to it for individual Records, but I haven't been able to get it to work yet.

Is there a way to look at instanced Control objects (for example: to check the value of Control X for Record 3, but not for Records 1 or 2)?

[Rawb]

Hrm, I just realized I could probably set something up where each Record is loaded in it's own Sub-Form. Then, since each Sub-Form is separate from all the others, I might be able to properly set the Controls on there...

[June7]

Is there a way to look at instanced Control objects (for example: to check the value of Control X for Record 3, but not for Records 1 or 2)?

It is possible to get the value of specific record by querying the form's Recordset but to what end? There is still only one set of controls in use for all records.