one form field to fill a field in two different tables 
Author Message
 one form field to fill a field in two different tables

Hi All,

After Update, I'm trying to get the data from a mainform
field to populate the underlying table of that field, and
then populate a subform field that is linked to a
different table. This is the code I'm using but it does
not work:

Private Sub CurrRVPspecInits_AfterUpdate()

[Forms]![Main]![RVHIST subform1].[Form]![RvpSpecInits] = _
    Forms![Main]![CurrRVPspecInits]

End Sub

I also need to do the same thing for a few fields going
from subform to mainform.

Anyone see what am I doing wrong?

Thanks,
John



Wed, 20 Oct 2004 00:12:38 GMT  
 one form field to fill a field in two different tables
On Fri, 3 May 2002 09:12:38 -0700, "John Tranter"

Quote:

>Hi All,

>After Update, I'm trying to get the data from a mainform
>field to populate the underlying table of that field, and
>then populate a subform field that is linked to a
>different table. This is the code I'm using but it does
>not work:

>Private Sub CurrRVPspecInits_AfterUpdate()

>[Forms]![Main]![RVHIST subform1].[Form]![RvpSpecInits] = _
>    Forms![Main]![CurrRVPspecInits]

Would it be appropriate to make CurrRVPSpecInits (part of) the Master
Link Field and RvpSpecInits the Child Link Field? Fills in
automatically if you do this...

                  John W. Vinson[MVP]    
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public



Wed, 20 Oct 2004 06:16:16 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Two Tables, Same Key Field, Same Record, Except One Field in Both Tables Different Value

2. two editable form-fields for one date/time-table-field in an contious form

3. linking two fields in one table to one field in another

4. Automatically fill a field from one form in another field on a seperate form

5. Move text in one field to two different fields

6. Auto filling fields in a form when selecting one field

7. Combining two fields in same table into One field

8. Combine two fields into one field in a table

9. One field with two formats, or two fields?

10. One field with two formats, or two fields?


 
Powered by phpBB® Forum Software © phpBB Group