Charlotte Foust
cfoust at infostatsystems.com
Fri Sep 3 15:03:17 CDT 2004
Look at the Application.CreateControl method for creating controls from code. If you want code behind that control, you need to add that to the form's module and set the control's named event to "[event procedure]" to connect them. Charlotte Foust -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Friday, September 03, 2004 12:32 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] JIT Forms? Well... The thing to understand is that a control is nothing more than VB code. You can export a form to text and see the vb code used to create it. Thus when you add a control to a form you are literally adding code to the form's module except that you are doing so via the design wizard. You can add code to the module directly, but it has to be in design view. I have never done this, but I know the concept. I have done manipulation of code in the modules before. I would advise looking at the form's vba to see what you need to do. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Thursday, September 02, 2004 11:47 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] JIT Forms? so the idea is to open the form up in design first add the fields? is that right? thanks, On Tue, 31 Aug 2004 13:47:27 -0400, John W. Colby <jwcolby at colbyconsulting.com> wrote: > You can do that but only in design view. > > John W. Colby > www.ColbyConsulting.com > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco > Tapia > Sent: Tuesday, August 31, 2004 11:46 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] JIT Forms? > > Anyone have a link, or advice on creating controls JIT? > > Access2000 / ADP > I have an unbound form, that I'd like to pass a recordset to and thus > be able to on-the-fly create controls that match the recordset... any > ideas? > > -- > -Francisco > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- -Francisco -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com