I am stuck right now and I am unsure what would be the best way to move forward, I have a form that is button launched from a main form. The main form and this form are linked via their id#. The problem I am at is there are two different types of information that a user would need to fill in depending on what the group code is next to the id#. So if someone has a LSE code then it would need to have 17 fields added to the datasheet (they are in their own table) and if it is MLS then their 23 values added to the datasheet but not all of the information when someone launches the form. I am at a loss as to which direction I need to go, any help is appreciated. I am adding a pic so you can see what is linked to what.
Datasheet to fill based on linked textfield
- Thread starter gumbi17
- Start date
apr pillai
AWF VIP
- Local time
- Today, 10:17
- Joined
- Jan 20, 2005
- Messages
- 737
If I am not mistaken you need two different sub-forms to the main to fill-in data, based on the Group-Code, into their related tables. If it is so then take a look at the following link:
Overlaying Sub-Forms in Real-time.
You can load either one of two sub-forms, depending on the Group Code selected, on the same location of a sub-form control. You can update two different tables as you need. In fact, you can use more than two forms in this way, if needed.
Overlaying Sub-Forms in Real-time.
You can load either one of two sub-forms, depending on the Group Code selected, on the same location of a sub-form control. You can update two different tables as you need. In fact, you can use more than two forms in this way, if needed.
Last edited:
