Tab form calculation

[Claire]

Hi

I have to "fix" a rather awkward database. Lucky Me!!

I have a subform called subProgress that resides on a main
form called frmContracts.

When a value in a subform combo box called cboProgress is
chosen I need a main form Tab Control called pgSummary to
refresh and a calculated control, txtGST, on the tab
control, to recalculate. Unfortunately, the main form is
not tied to a table or query. All of the objects are
unbound.

I am having trouble referencing the calculated control on
the tab page.

Any help would be huge.

Thanks

 

[Marin Kostov]

I have tried to reference the control, as part of the Tab control, and the
page on which the text box is. But... this is difficult for me, or not
possible.
I made something very simple:
A Form, a tab control (with name tab1 or whatever), a textbox control on its
first page with name txtTest. Outside the Tab control I placed a command
button, cmdClick. In its OnClick Event I added the code:

Private Sub cmdClick_Click()
txtTest.SetFocus
MsgBox txtTest.Text
End Sub

Without setting the Focus to the TextBox, you CANNOT reference it. Access
displays a Message telling so, when the line txtTest.SetFocus is not there.
I hope this will help you.

 

[Claire]

Thanks Marin.

I will give it a try.