[Accessusergroup] Update one field from another
YALE Denise C
Denise.C.YALE at odot.state.or.us
Wed Nov 1 07:36:26 PST 2006
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
As I'm writing this, I'm confusing myself. I'll try your idea and see
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
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
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.
denise.c.yale at odot.state.or.us
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the AccessUserGroup