Can new form controls be created on the fly depending on a recordset?
for instance in the onload method?

sub Form_Load()
  get all the data ready in a recordset
  then create the appropriate amount of labels text fields and
  check boxes.

Make them all visible
end sub

Thanks
-Roni

Roni Estein
[email protected]
https://www.e-drugsCanada.com

__________________
Roni Estein
[email protected]
https://www.e-drugsCanada.com

There may be another way of doing this. What are you after?
You can not create control arrays as you would in VB6, but, you can create a form in continuous form default and maybe use it for this.



Sal

I am kind of after the elusive consolidate function that I am reffing to in the Complicated Query http://p2p.wrox.com/topic.asp?TOPIC_ID=7540.

I am trying to do this in kind of a round about CompSci 101 type fashion. Create a 2D array from the recordset plus the added in false values for all the choices. Map those onto unbound fields. and use them to create the selection criteria for the that same refill question. I've read that this is not such a fast way to do things and that normally injecting new controls onto a form is a lot of overhead, but I'm not sure, or wasn't at the time aware of any other way of accomplishing this task. Perhaps those triggers will work or the ADO once I know how to approach it.

Best Regards,
-Roni

Roni Estein
[email protected]
https://www.e-drugsCanada.com

Roni

I could send you a couple of forms which do almost what you're looking for.

They should give you a starting point at least.

Let me know.


Brian Skelton
Braxis Computer Services Ltd.

Does the FormOnTheFly help at:

http://www.candace-tripp.com/access_downloads.htm

Clive Astley

Hi Brian & Clive,

Brian, that would be fantastic if you have the time.
You can email me at [email protected] and let me know where I could check those out. I really appreciate it.

Clive, I will check out that URL ASAP, thanks for in advance for the tip.

Best Regards,
-Roni


Roni Estein
[email protected]
https://www.e-drugsCanada.com

I once did something of this sort using
Access.CreateControl
method but I found that it took a lot of time each time the form loads.
Maybe I was not using the right method but I did not find it helpful to have controls created each time the form loads.