I have a Form which has 2 Tabs which contain separate aspects of information that are related to the same PartID.
What I am trying to do is to come up with a method so that if there is a Description entered into the Reliability Tab (and the Decription Part ID value on the Reliability Tab has a value) then the Text Box on the General Information Tab called Reliability Programme Present?: should show YES.
The way the user would input the data would be:
I have been fumbling around and something like the code below should work, but it gives me issues whenever I click on the Reliability Tab as Me.ReliabilityProgrammePresent is only present on the General Information Tab and not on the Reliability Tab.
Any way to resolve this? What about the idea of identifying whether Me.ReliabilityProgrammePresent is on the Tab or not?
I am not too familiar with Page properties.
Happy to talk it through if there are any questions.
What I am trying to do is to come up with a method so that if there is a Description entered into the Reliability Tab (and the Decription Part ID value on the Reliability Tab has a value) then the Text Box on the General Information Tab called Reliability Programme Present?: should show YES.
The way the user would input the data would be:
- Enter the Part ID at the top e.g 7155
- On the General Information Tab the user would enter a Description e.g TEST 7155
- The user would then go to the Reliability Tab and then enter a Description e.g TEST RELIABILITY.
- The user would then go back to the General Information Tab and should be able to see the "Reliability Programme Present?:" Box filled with YES.
I have been fumbling around and something like the code below should work, but it gives me issues whenever I click on the Reliability Tab as Me.ReliabilityProgrammePresent is only present on the General Information Tab and not on the Reliability Tab.
Code:
If Parent.PartID = Me.PartID Then
Me.ReliabilityProgrammePresent = "YES"
End If
Any way to resolve this? What about the idea of identifying whether Me.ReliabilityProgrammePresent is on the Tab or not?
I am not too familiar with Page properties.
Happy to talk it through if there are any questions.