Tab control problem

[Jackie]

Hi all

New to the forum so would just like to say hi first

I'm having some problems with a tab control form - I have three pages on the form and what I want to do is when a check box it ticked I want some text boxes to be copied over to other text boxes which works fine until one of the text boxes is on the other page

Code is:

Private Sub CustomerTenant_AfterUpdate()
If CustomerTenant = -1 Then
Me.TenantsHouse = Me.HouseNumber
Me.TenantsAddress = Me.Address
Me.TenantsEstate = Me.Estate


Me.TenantsTown = Me.Town
Me.TenantsPostcode = Me.Postcode
TabControl1.Pages(1).TenantsForename = Me.Forename
End If
End Sub

Can't seem to get this to work and I'm rubbish at explaining things so hope you can understand whatb i mean

any help would be great cheers

jackie

[pbaldy]

Disregard the tab when referring to the textbox. Presuming there's no subform involved:

Me.TenantsForename = Me.Forename

[Jackie]

Hi Cheers thanks for that I had tried this before but it wouldnt work just relised the text field was called TenantForename not TenansForename (forgot the s) really silly real blonde moment!!!

Cheers

[pbaldy]

No problemo; we all have blond moments! Welcome to the site by the way.