Auto-completing fields

R

Rush

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!
 
J

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
 
R

Rush

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?
 
M

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
Click to expand...
[quoted text clipped - 16 lines]
Click to expand...
 
R

Rush

Thank you for your help. That worked perfectly.

missinglinq via AccessMonster.com said:
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
Click to expand...
[quoted text clipped - 16 lines]
Can anyone help me?
Thank you!
Click to expand...
Click to expand...
Click to expand...
 
J

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
 
Top