If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto-completing fields
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! |
#2
|
|||
|
|||
Auto-completing fields
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 "Rush" wrote in message ... 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! |
#3
|
|||
|
|||
Auto-completing fields
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? "Jeff Boyce" wrote: 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 "Rush" wrote in message ... 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! |
#4
|
|||
|
|||
Auto-completing fields
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 Rush wrote: 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! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
Auto-completing fields
Thank you for your help. That worked perfectly.
"missinglinq via AccessMonster.com" wrote: 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 Rush wrote: 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! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via http://www.accessmonster.com |
#6
|
|||
|
|||
Auto-completing fields
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 "Rush" wrote in message ... 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? "Jeff Boyce" wrote: 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 "Rush" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|