Search results

Hi everybody, I have a button on the main form to delete records on a subform. I use this code: Private Sub BtnDeleteContact_Click() Dim Respons As String Dim Msg, Style, Title, Response As String Msg = "You are about to delete this contact." Style = vbOKCancel + vbQuestion +...

The case statement works. Probably not the best way to solve this but, well, not bad for an amature... Private Sub Form_Open(Cancel As Integer) Select Case NumberOfUnits Case 0 Me.Unit_1.Visible = False Me.Unit_2.Visible = False Me.UNIT_3.Visible = False Me.UNIT_4.Visible...

ok here goes: when the form opens: the value for number of tabs from the table = e.g. 4 which means I have to hide tab 5 to 10. The name of the tabs are: tab1(index 0) = General, tab2(index 1) = Unit_1 tab3(index 2) = Unit_2 etc. I have been experimenting with Do While with a counter starting...

Yes it does help. Now all I need to do is come up with a smart While n > statement or something to hide all tabs which the user should not see. Cheers.

Hi DCrake, Thanks for your reply. Let me try and explain the functionality of the form. The user will be able to enter data in a subform (continues) which I put on the main form on top of the tab control. So just one sub form. Depending on the value of the record (1 to 10) I want to show an...

Hello, I have a form bound to a table, in the table I have a record with a number from 0 to 10. Depending on that number from the record I want to show the TabControl with a number of pages equal to the number from the table + 1 (e.g 0 = 1 Tab page, 3 = 4 Tab Pages). Can anyone help me with the...