MERRY CHRISTMAS and HAPPY HOLIDAYS to one and all from the Holmes Family
Hi All:
This thread is LOOSELY related to 2 others:
- https://www.accessforums.net/showthread.php?t=74889
- https://www.accessforums.net/showthread.php?t=74911
The database and input forms seem to be working quite nicely, and I am getting the reports together, so I have moved on to another part of the project.
Being that this is a model railroad database, there can be a lot of paperwork associated with running each train. In model railroad parlance, we call these orders. Some are informational, containing instructions about how to operate a particular locomotive, or they can be maintainance related etc. each type has a specific set of instructions which can fit nicely in to 20 fields, so I have created a table that has 21 lines; OrderID_PK (the primary key and set auto number/long int), Field_1 - Field_19, and a field called instructions - All of them set as Short text.
I know that I can create 8 different forms, and have done with it, but I'd like to see if I can do it a bit more classy.
What I want to do is have a form where I use a combo or list box to select the type of form that I am populating, and have it pull up another form, or sub form or whatever that is appropriate to the type of order that I am creating. The problem is that I dont know how to do this, I SUSPECT that it would be a form/Subform combination (I know they are mostly used in a 1 to many relationship, but I suspect you could make the subform a regular form, and set it all for data entry)
This thread is also posted in the UtterAccess form at: https://www.utteraccess.com/forum/in...wtopic=2051989
Any input would be greatly appreciated
TIM