I'm new to using ActiveX controls and somewhat rusty in using VBA. I need to implement (and interact with) an ActiveX control on a form. In general, what are the necessary steps in getting it recognized and working?

Other than drag and drop, you may have to register it.

Once it is on the form, then you need to tell it where to store the values it generates.

There is a list of registered ActiveX controls in the Forms toolbox at the end where it says More Controls.

Any control you insert, you will have to make sure is registered on every desktop where you want to put your app. If you purchase a control, it will have registration instructions. Once you register it, it will show up in the More Controls list.

Does this help?

mmcdonal

Following up on this... I guess I'm doing somthing similar. I have created my own Activex control that contains several texboxes. I wish to deposit one of the values in one of the textboxes on the activex control into a table via an update query. Can anyone tell me how to reference its contents? ie if the form name is form1, the activex control is named customactivex1, and the textbox is named textbox1, the following don't work when typed into the "Update To:" field of the query. What does?
Forms!form1!customactivex1!textbox1
Forms!form1!customactivex1.textbox1