[Accessusergroup] Update one field from another

[YALE Denise C]

See I knew you were going to say that. They aren't the same field
although they have the same info. Let me do some splainin'
The AgencySentTo field in the main form is used to determine the report
that will be used (where it will be sent).  The agency in the subform
indicates what agency is concerned with that particular species.  The
example form I showed below is pretty straight forward--one species per
report.  But I have another form that has multiple species and multiple
agencies. 
As I'm writing this, I'm confusing myself.  I'll try your idea and see
what happens
 
Thanks
 
 
 -----Original Message-----
From: HARGROVE Thomas M * Mike 
Sent: Wednesday, November 01, 2006 7:19 AM
To: YALE Denise C
Subject: RE: [Accessusergroup] Update one field from another



	If they are in fact the identical field, there is no point in
storing the data twice.  Just make a pointer from the Subform to the
SingleNLAA dataset.

________________________________

	From: accessusergroup-bounces at listsmart.osl.state.or.us
[mailto:accessusergroup-bounces at listsmart.osl.state.or.us] On Behalf Of
YALE Denise C
	Sent: Wednesday, November 01, 2006 7:13 AM
	To: AccessUserGroup at listsmart.osl.state.or.us
	Subject: [Accessusergroup] Update one field from another
	
	

	Thought I'd give you a little brain teaser this morning. 

	This should be a simple thing, but it just eludes me. 

	I have a form with a subform 

	FRM_BATrans_SingleNLAA  SFM_SubFormSpecies 
	PrimaryKey                      PrimaryKey      
	AgencyBeingSentTo               Agency 
	RegContact                      SpeciesName 
	Etc.                            etc. 

	The forms are linked by the primary key.  I want the agency
field in the subform  to update to whatever is entered in the
AgencyBeing SentTo field in the main form. I can get the Agency field to
update on the screen using the =AgencyBeingSentTo, but it's not saving
the info to the Agency field of the species table.

	Picture (Metafile) 

	Denise Yale 
	503.986.3978 
	denise.c.yale at odot.state.or.us 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listsmart.osl.state.or.us/pipermail/accessusergroup/attachments/20061101/a9316dbe/attachment.htm