PC Review


Reply
Thread Tools Rate Thread

Acc2002 - Form/subform

 
 
ericaz511@gmail.com
Guest
Posts: n/a
 
      12th Jun 2007
I have a main form with a combo box and a subform. The combo box
contains a list of 15 tables.

I want to be able to select a table from the combo box, and then have
the table show in the subform, so I can then edit the table.

Since each table contains different fields, does that mean I need to
create a separate form for each of the 15 tables? Is there a way
around this?

I tried setting the RecordSource dynamically (in the combo box
AfterUpdate event), but I'm not sure how to handle the controls on the
subform, since the controls will be different for each table.

Any ideas would be much appreciated!

Thanks,
Erica.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Acc2002 - Form/subform ericaz511@gmail.com Microsoft Access Form Coding 0 12th Jun 2007 05:25 AM
Subform closes after form... subform searching for form controls =?Utf-8?B?dGl0bGVwdXNoZXI=?= Microsoft Access Form Coding 1 17th Oct 2005 01:04 AM
Acc2002: form code doesn't see code in other modules A man Microsoft Access VBA Modules 3 7th Sep 2004 05:40 PM
ACC2002: Custom MenuBar does not load with Form Tony_VBACoder Microsoft Access Forms 2 13th May 2004 03:37 PM
[INFO] ACC2002: You Cannot Update a Form That Is Bound to an ADO Oracle Recordset in an Access Database Project Eva Etxebeste Microsoft Access ADP SQL Server 1 7th Feb 2004 02:39 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:29 PM.