how to create checkboxes on form-load?? (VERY URGENT)

[frag]

Hi there, it's me again... frag!

I have another problem!
I want to create some checkboxes (corresponding to a database field) on form-load for a form i have created in design-view.
Here is my code...

------------------------------------------------------------
Private Sub Form_Load()

Dim ctlCheckbox As Control

Set ctlCheckbox = CreateControl(Form.Name, acCheckBox,
acDetail, "", "", 100, 100)

End Sub
------------------------------------------------------------

I keep getting this error-msg:
Run-time error '2147':
You must be in Design view to create or delete views.


What's wrong?

thanx.

frag

 

[frag]

uuuups...

there is something i forgot:

i am using VBA for Access 97

 

[Durkin]

The reason you're getting that message is because the CreateControl function can only add controls to a form that is in design view. It's really meant for creating your own wizards and things like that. Possibly what you could do is open the form intially in design view, add your controls and then open it normally. Try something along the lines of:

Public Sub MakeCtls()

    DoCmd.OpenForm "form1", acDesign, , , , acHidden
    CreateControl "form1", acTextBox, acDetail, , 15, 15, 15, 1500, 500
    DoCmd.OpenForm "form1"
    
End Sub

Durkin
alandurkin@bigpond.com

 

[frag]

Hi Durkin!

Thanx for your reply.
I have checked out your piece of code... but this doesn't work either.

Run-time error '2174':
You can't switch to a diffrent view at this time.
Code was executing when you tried to switch views.
If you are debugging code, you must end the debugging operation before switching views.

I will just set my checkboxes to invisble and set them to visible at runtime when i need them. Ugly, but it works.

Thanx!

frag patrick.metz@epost.de

 

[scking]

I'm unsure why you would need to create a control when the form opens. Maybe the following would satisfy your requirement: creating the controls normally and setting their visible properties to false. Then, when the form opens you set the visible property to true on whatever control you would need. Another possibility would be to manage properties of a single control during the open event. Hope one of these would help.

 

[frag]

Hi scking!

Thanx for your reply.

1. visible/invisible
--------------------
I already mentioned this in my last replay!


2. Why I need to create controls on formload
-------------------------------------------
I get data from a database table. According to this data
I have to set controls to visible/unvisible. Thought it
would be nicer to have a dynamic form with dynamic
controls (for saving place on the desktop).

But anyway... forget it. The app is finish and rolled out.

cya

frag patrick.metz@epost.de