A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

linking subform to mainform field



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 6th, 2005, 05:29 PM
Pearl
external usenet poster
 
Posts: n/a
Default linking subform to mainform field

I have a main form that has a field called LastName. I also have a subform
that also has a field called LastName. I placed that field in the subform to
be able to correlate the subform to the mainform BUT what I want is that each
time I open the form to a specific LastName in the main form that the subform
field called LastName will auto populate with the same value in the mainform
field called LastName. How do I do this? I have done this a long time ago
but can not remember how I did this. I recall I did this completely using
the Build option in properties of the field and did not use VBA ( I am not
versed in VBA and would prefer to not do this in VBA). Can anyone assist?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Design help, please SillySally Using Forms 27 March 6th, 2005 04:11 AM
Update field value automatically based on subform Sammie Using Forms 0 February 11th, 2005 09:49 PM
Form Subform data export [email protected] Using Forms 6 January 6th, 2005 06:25 PM
Need help with cascading combos Tom Using Forms 19 July 1st, 2004 11:11 PM
Recordset in subform based on field in parent form Lyn General Discussion 15 June 14th, 2004 03:10 PM


All times are GMT +1. The time now is 05:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.