M
M
Michael2020-07-16 12:43:32
Visual Basic
Michael, 2020-07-16 12:43:32

How to display information from multiple tabs in static form fields?

There is: a form with 3 tab bars (each tab bar corresponds to a contract type), displayed and hidden using a group of radio buttons (by changing the visible property).
Each tab (there are 3 of them) contains information about the contract, including its expiration date.
Needed: to make a brief display of information about contracts in any part of the form based on the contents of the field with the expiration date of the contract. That is, you should get something like:
Contract type A: valid
Invalid
Not available
Contract type A: valid
Not available
Not available
, etc.

View Code
Select case me.TabDatefield1.value
case 0 'if the date is empty
Me.Display1.text = "None"
case is > Date
Me.Display1.text = "Valid"
Case is < Date
Me.Display1.text = "Invalid"
End select

doesn't work - display window remains empty.
Tell me, good people, what to do? I have little experience in programming, I program mainly for small office needs. Well, or where to look. I searched for a long time on the Internet before writing a post here - I did not find similar cases.
Thanks in advance for any help!

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question