Auto-completing fields

[Guest]

I am wondering if the following is possible...
I have a tabbed form with 2 tabs. After I enter some information on the
first tabbed page, and I click on the second tab, I want some of the
information to automatically appear in some of the fields on the second page
that correspond to fields on the first tabbed page. The fields have
different names, or else I'd just put them outside of the tabs and let them
remain the same while I changed pages.
Can anyone help me?
Thank you!

 

[Jeff Boyce]

Why? As in "why do you have the same data called two different names?" One
of the advantages of a well-normalized relational database is that you only
need to store a particular fact once.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hey, that wasn't the question. I was asking if it could be done. I didn't
design the database, and can't change it now due to where the data is coming
from. So, can it be done?

 

[missinglinq via AccessMonster.com]

Jeff's point is valid, but sure it can be done! The real secret is that the
tabbed pages are really just one form. Use this code, replacing the text box
names with your own names.

Private Sub Tab1TextBox_BeforeUpdate(Cancel As Integer)
Me.Tab2TextBox.Value = Me.Tab1TextBox.Value
End Sub

Hey, that wasn't the question. I was asking if it could be done. I didn't
design the database, and can't change it now due to where the data is coming
from. So, can it be done?

Why? As in "why do you have the same data called two different names?" One
of the advantages of a well-normalized relational database is that you only

[quoted text clipped - 16 lines]

 

[Guest]

Thank you for your help. That worked perfectly.

Jeff's point is valid, but sure it can be done! The real secret is that the
tabbed pages are really just one form. Use this code, replacing the text box
names with your own names.

Private Sub Tab1TextBox_BeforeUpdate(Cancel As Integer)
Me.Tab2TextBox.Value = Me.Tab1TextBox.Value
End Sub

Hey, that wasn't the question. I was asking if it could be done. I didn't
design the database, and can't change it now due to where the data is coming
from. So, can it be done?

Why? As in "why do you have the same data called two different names?" One
of the advantages of a well-normalized relational database is that you only

[quoted text clipped - 16 lines]

Can anyone help me?
Thank you!

 

[Jeff Boyce]

Rush

As missinglinq points out, you certainly can. I would have been remiss if I
hadn't asked the purpose ... after all, I can drive nails with my chainsaw
.... but it isn't a very good idea!

Regards

Jeff Boyce
Microsoft Office/Access MVP