combo box opens subform from the same table

  • Thread starter Thread starter Gino via AccessMonster.com
  • Start date Start date
G

Gino via AccessMonster.com

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
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
Click to expand...

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

John said:
created company form with a combo box to open subform for input data only for
that type of company
Click to expand...
[quoted text clipped - 4 lines]
input to many fields to skip
thanks Gino
Click to expand...

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]
Click to expand...
 
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
Click to expand...

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

John said:
now i gave the subform working in the form and it works when is the error
message show on the long run
Click to expand...
[quoted text clipped - 3 lines]
made last database ten years ago so a lot is changed and only 10 tables
involved
Click to expand...

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]
Click to expand...
 
Back
Top