Hi,
I have a table with 15 fields
The first 5 fields are generic (including the KeyID)
The next 5 fields relate to a particular scenario and the remaining 5 fields relate to another scenario.
I have created 2 forms for the 2 different scenarios with the fist 5 fields being the same. The forms are set to go to new record when loaded.
I can open Form 1 with no problem but cannot open Form 2.
I’m guessing it is because both forms are using the same KeyID.
Is there a way to get around this?
I have tried using 2 subforms but it looks really messy. Is it possible for both subforms to be invisible and on clicking on a command button, open the subform that is required?
Any creative suggestions would be greatly appreciated.
Many thanks
I have a table with 15 fields
The first 5 fields are generic (including the KeyID)
The next 5 fields relate to a particular scenario and the remaining 5 fields relate to another scenario.
I have created 2 forms for the 2 different scenarios with the fist 5 fields being the same. The forms are set to go to new record when loaded.
I can open Form 1 with no problem but cannot open Form 2.
I’m guessing it is because both forms are using the same KeyID.
Is there a way to get around this?
I have tried using 2 subforms but it looks really messy. Is it possible for both subforms to be invisible and on clicking on a command button, open the subform that is required?
Any creative suggestions would be greatly appreciated.
Many thanks