 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005combo box opens subform from the same table
created company form with a combo box to open subform for input data only for that type of company the combo box is company type ( hotel or transportation ) on list click hotel and hotel subform must open and ready for input in fieldd than close the hotel subform there will be like 9 different subforms to ad info the reason for subforms is i don`t need all that info in the company form on input to many fields to skip thanks Gino >created company form with a combo box to open subform for input data only for >that type of company [quoted text clipped - 4 lines] >input to many fields to skip >thanks Gino Having a Subform and a main form open to the same record is not a good idea - you'll get conflicts, error messages saying "another user has the record open for editing". If you just need screen real estate, consider using a Tab control with additional controls on each page. If you have SO many fields in your table that you need a form and nine subforms (or nine tab pages) to display it... STOP! A table with 30 fields is getting too wide already. If you have more, you almost surely need to redesign your table structure rather than messing around with subforms or tab pages! John W. Vinson[MVP] now i gave the subform working in the form and it works when is the error message show on the long run adding more tables will put me to about 100 tables not every form has four fields most of them have only one field made last database ten years ago so a lot is changed and only 10 tables involved >>created company form with a combo box to open subform for input data only for >>that type of company [quoted text clipped - 16 lines] > > John W. Vinson[MVP] >now i gave the subform working in the form and it works when is the error >message show on the long run [quoted text clipped - 3 lines] >made last database ten years ago so a lot is changed and only 10 tables >involved I'm sorry, Gino, I cannot make any sense of this. I don't even know if it's intended as a question. John W. Vinson[MVP] have the form with the subform working from the same table now and found no errors let`s say if we put code thru combo box what code do i need to make it work and where to put the codes in >>now i gave the subform working in the form and it works when is the error >>message show on the long run [quoted text clipped - 6 lines] > > John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.