AfterUpdate

I want to have a field [Store] that stores the value of ContactName.Column(1)
after the user selects a contact name.

I tried making an "EventProcedure" on the AfterUpdate property of Contact
Name:

[Store]=ContactName.Column(1)

but it isn't working. How would I fix this?

"...isn't working..." leaves a lot open for the imagination.

By the way, I'm hoping the "... that stores the value of ..." comment meant
"... that displays the value of...". Since you are working in MS Access, a
relational database, you don't need to redundantly store the Store.

A more specific description will probably lead to more specific
suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"awach" wrote in message
...
I want to have a field [Store] that stores the value of
ContactName.Column(1)
after the user selects a contact name.

I tried making an "EventProcedure" on the AfterUpdate property of Contact
Name:

[Store]=ContactName.Column(1)

but it isn't working. How would I fix this?

awach,
It appears that you've posted this question several times. Please stay with one thread
while folks are trying to help. Otherwise folks will end up offering duplicate solutions,
and the "flow" of the problem won't be clear. Keep all the posts together so responders
can see what the progression has been during the problem determination procedure.
Also, what does "isn't working" mean exactly.

Try this test... just place a
Beep
in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when
you select an item?

And...
Try this test... place an unbound text control on the form, and give it a ControlSource
of...
=ContactName.Column(1)
Does it display the correct value you want to see from the ContactName combo?

Your EventProcedure should be run on the AfterUpdate event of the ContactName combo.

Store should be a "bound" text control

I take it you placed the
[Store]=ContactName.Column(1)
in the form module, and not just in the text box for the ContactName AfterUpdate event.
(sorry but I have to ask)

OK, please answer these very basic questions, and we'll keep "drilling down" till we
figure out why it doesn't work. This is a very simple process, so I suspect there is
something you haven't indicated in your posts, or something we're not understanding about
your setup, that's causing the problem.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions





"awach" wrote in message
...
I want to have a field [Store] that stores the value of ContactName.Column(1)
after the user selects a contact name.

I tried making an "EventProcedure" on the AfterUpdate property of Contact
Name:

[Store]=ContactName.Column(1)

but it isn't working. How would I fix this?

Al

I was with you up to the part about [Store] being a bound column. If the
data is already available elsewhere, and the OP would use something like a
combobox (with columns) to find the correct store, wouldn't storing the ID,
rather than the text, make more sense?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Al Campagna" wrote in message
...
awach,
It appears that you've posted this question several times. Please stay
with one thread while folks are trying to help. Otherwise folks will end
up offering duplicate solutions, and the "flow" of the problem won't be
clear. Keep all the posts together so responders can see what the
progression has been during the problem determination procedure.
Also, what does "isn't working" mean exactly.

Try this test... just place a
Beep
in the AfterUpdate event procedure, and update your ContactName combo.
Get a beep when you select an item?

And...
Try this test... place an unbound text control on the form, and give it
a ControlSource of...
=ContactName.Column(1)
Does it display the correct value you want to see from the ContactName
combo?

Your EventProcedure should be run on the AfterUpdate event of the
ContactName combo.

Store should be a "bound" text control

I take it you placed the
[Store]=ContactName.Column(1)
in the form module, and not just in the text box for the ContactName
AfterUpdate event. (sorry but I have to ask)

OK, please answer these very basic questions, and we'll keep "drilling
down" till we figure out why it doesn't work. This is a very simple
process, so I suspect there is something you haven't indicated in your
posts, or something we're not understanding about your setup, that's
causing the problem.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions





"awach" wrote in message
...
I want to have a field [Store] that stores the value of
ContactName.Column(1)
after the user selects a contact name.

I tried making an "EventProcedure" on the AfterUpdate property of Contact
Name:

[Store]=ContactName.Column(1)

but it isn't working. How would I fix this?

Jeff,
I thought the problem was that Awach couldn't get the AfterUpdate of his combo box to
set the value for Store.

I assumed that ContactName is a combo with StoreID in Col(0), and Store (Name?) in
Col(1). Col(0) would be hidden, and I assumed ContactName is actually bound to StoreID.
(I don't think I've pieced together "all" the various separate posts on this problem,
but that's what gathered from this latest thread.)

It was previously suggested by Klatuu... and you... that capturing Store was not
advisable, (I agree) but in other posts I saw, the OP indicated he "had" to save it. (I
still don't see why though)
So... I took it that Store would be bound field that will use the AfterUpdate of combo
ContactName to set it's value from the Col(1) text.

I tried making an "EventProcedure" on the AfterUpdate property of Contact
[Store]=ContactName.Column(1)
but it isn't working. How would I fix this?

The balance of my post was suggestions that might help determine why the OP's code...
"isn't working".

Did I miss, or misunderstand, something about what the OP wants... or has... so far?
--
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions



"Jeff Boyce" wrote in message
...
Al

I was with you up to the part about [Store] being a bound column. If the data is
already available elsewhere, and the OP would use something like a combobox (with
columns) to find the correct store, wouldn't storing the ID, rather than the text, make
more sense?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Al Campagna" wrote in message
...
awach,
It appears that you've posted this question several times. Please stay with one
thread while folks are trying to help. Otherwise folks will end up offering duplicate
solutions, and the "flow" of the problem won't be clear. Keep all the posts together
so responders can see what the progression has been during the problem determination
procedure.
Also, what does "isn't working" mean exactly.

Try this test... just place a
Beep
in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when
you select an item?

And...
Try this test... place an unbound text control on the form, and give it a
ControlSource of...
=ContactName.Column(1)
Does it display the correct value you want to see from the ContactName combo?

Your EventProcedure should be run on the AfterUpdate event of the ContactName combo.

Store should be a "bound" text control

I take it you placed the
[Store]=ContactName.Column(1)
in the form module, and not just in the text box for the ContactName AfterUpdate event.
(sorry but I have to ask)

OK, please answer these very basic questions, and we'll keep "drilling down" till we
figure out why it doesn't work. This is a very simple process, so I suspect there is
something you haven't indicated in your posts, or something we're not understanding
about your setup, that's causing the problem.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions





"awach" wrote in message
...
I want to have a field [Store] that stores the value of ContactName.Column(1)
after the user selects a contact name.

I tried making an "EventProcedure" on the AfterUpdate property of Contact
Name:

[Store]=ContactName.Column(1)

but it isn't working. How would I fix this?

Jeff,
This part of my last post should read...

I assumed that ContactName is a combo with StoreID in Col(0), and store's
(ContactName?) in
Col(1). Col(0) would be hidden, and I assumed ContactName is actually bound to StoreID.
I'm a bit confoosed about the OP's naming scheme... I would have set it up this way
StoreID StoreName ContactName
142 Boston John Doe
and then gone for Col(2)... select a store by name, and then AfterUpdate...
ContactName = OPsCombo.Column(2)

Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Jeff Boyce" wrote in message
...
Al

I was with you up to the part about [Store] being a bound column. If the data is
already available elsewhere, and the OP would use something like a combobox (with
columns) to find the correct store, wouldn't storing the ID, rather than the text, make
more sense?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Al Campagna" wrote in message
...
awach,
It appears that you've posted this question several times. Please stay with one
thread while folks are trying to help. Otherwise folks will end up offering duplicate
solutions, and the "flow" of the problem won't be clear. Keep all the posts together
so responders can see what the progression has been during the problem determination
procedure.
Also, what does "isn't working" mean exactly.

Try this test... just place a
Beep
in the AfterUpdate event procedure, and update your ContactName combo. Get a beep when
you select an item?

And...
Try this test... place an unbound text control on the form, and give it a
ControlSource of...
=ContactName.Column(1)
Does it display the correct value you want to see from the ContactName combo?

Your EventProcedure should be run on the AfterUpdate event of the ContactName combo.

Store should be a "bound" text control

I take it you placed the
[Store]=ContactName.Column(1)
in the form module, and not just in the text box for the ContactName AfterUpdate event.
(sorry but I have to ask)

OK, please answer these very basic questions, and we'll keep "drilling down" till we
figure out why it doesn't work. This is a very simple process, so I suspect there is
something you haven't indicated in your posts, or something we're not understanding
about your setup, that's causing the problem.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions





"awach" wrote in message
...
I want to have a field [Store] that stores the value of ContactName.Column(1)
after the user selects a contact name.

I tried making an "EventProcedure" on the AfterUpdate property of Contact
Name:

[Store]=ContactName.Column(1)

but it isn't working. How would I fix this?

Al

Sorry for the delay -- I live in the path of that quasi-hurricane that blew
through Washington state last week, and still don't have power at home.

When I responded to the OP, I didn't feel I had enough info to make an
informed suggestion. I was just posing a question about the notion of
(re-)storing a Store Name.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Al Campagna" wrote in message
...
Jeff,
This part of my last post should read...

I assumed that ContactName is a combo with StoreID in Col(0), and
store's (ContactName?) in
Col(1). Col(0) would be hidden, and I assumed ContactName is actually
bound to StoreID.
I'm a bit confoosed about the OP's naming scheme... I would have set it
up this way
StoreID StoreName ContactName
142 Boston John Doe
and then gone for Col(2)... select a store by name, and then
AfterUpdate...
ContactName = OPsCombo.Column(2)

Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Jeff Boyce" wrote in message
...
Al

I was with you up to the part about [Store] being a bound column. If the
data is already available elsewhere, and the OP would use something like
a combobox (with columns) to find the correct store, wouldn't storing the
ID, rather than the text, make more sense?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Al Campagna" wrote in message
...
awach,
It appears that you've posted this question several times. Please
stay with one thread while folks are trying to help. Otherwise folks
will end up offering duplicate solutions, and the "flow" of the problem
won't be clear. Keep all the posts together so responders can see what
the progression has been during the problem determination procedure.
Also, what does "isn't working" mean exactly.

Try this test... just place a
Beep
in the AfterUpdate event procedure, and update your ContactName combo.
Get a beep when you select an item?

And...
Try this test... place an unbound text control on the form, and give
it a ControlSource of...
=ContactName.Column(1)
Does it display the correct value you want to see from the ContactName
combo?

Your EventProcedure should be run on the AfterUpdate event of the
ContactName combo.

Store should be a "bound" text control

I take it you placed the
[Store]=ContactName.Column(1)
in the form module, and not just in the text box for the ContactName
AfterUpdate event. (sorry but I have to ask)

OK, please answer these very basic questions, and we'll keep "drilling
down" till we figure out why it doesn't work. This is a very simple
process, so I suspect there is something you haven't indicated in your
posts, or something we're not understanding about your setup, that's
causing the problem.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions





"awach" wrote in message
...
I want to have a field [Store] that stores the value of
ContactName.Column(1)
after the user selects a contact name.

I tried making an "EventProcedure" on the AfterUpdate property of
Contact
Name:

[Store]=ContactName.Column(1)

but it isn't working. How would I fix this?

Jeff,
No problem...
I've been in contact with a friend from this NG (near Redmond) when I heard the news
about the storm/s in the Northwest. He didn't have power either.
He had to email from work.
Pretty nasty affair...
Hope your OK, and that you'll get power soon.

I'm still confoosed about the OP's setup, and the necessity for "saving" any combo
column in the situation as I understood it.
So I just ignored the setup and just tried to deal with the upshot of the problem.

The OP hasn't responded since. I think I scared him off! :-D

Have a good holiday Jeff,
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Jeff Boyce" wrote in message
...
Al

Sorry for the delay -- I live in the path of that quasi-hurricane that blew through
Washington state last week, and still don't have power at home.

When I responded to the OP, I didn't feel I had enough info to make an informed
suggestion. I was just posing a question about the notion of (re-)storing a Store Name.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Al Campagna" wrote in message
...
Jeff,
This part of my last post should read...

I assumed that ContactName is a combo with StoreID in Col(0), and store's
(ContactName?) in
Col(1). Col(0) would be hidden, and I assumed ContactName is actually bound to
StoreID.
I'm a bit confoosed about the OP's naming scheme... I would have set it up this way
StoreID StoreName ContactName
142 Boston John Doe
and then gone for Col(2)... select a store by name, and then AfterUpdate...
ContactName = OPsCombo.Column(2)

Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Jeff Boyce" wrote in message
...
Al

I was with you up to the part about [Store] being a bound column. If the data is
already available elsewhere, and the OP would use something like a combobox (with
columns) to find the correct store, wouldn't storing the ID, rather than the text,
make more sense?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Al Campagna" wrote in message
...
awach,
It appears that you've posted this question several times. Please stay with one
thread while folks are trying to help. Otherwise folks will end up offering
duplicate solutions, and the "flow" of the problem won't be clear. Keep all the
posts together so responders can see what the progression has been during the problem
determination procedure.
Also, what does "isn't working" mean exactly.

Try this test... just place a
Beep
in the AfterUpdate event procedure, and update your ContactName combo. Get a beep
when you select an item?

And...
Try this test... place an unbound text control on the form, and give it a
ControlSource of...
=ContactName.Column(1)
Does it display the correct value you want to see from the ContactName combo?

Your EventProcedure should be run on the AfterUpdate event of the ContactName
combo.

Store should be a "bound" text control

I take it you placed the
[Store]=ContactName.Column(1)
in the form module, and not just in the text box for the ContactName AfterUpdate
event. (sorry but I have to ask)

OK, please answer these very basic questions, and we'll keep "drilling down" till
we figure out why it doesn't work. This is a very simple process, so I suspect there
is something you haven't indicated in your posts, or something we're not
understanding about your setup, that's causing the problem.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions





"awach" wrote in message
...
I want to have a field [Store] that stores the value of ContactName.Column(1)
after the user selects a contact name.

I tried making an "EventProcedure" on the AfterUpdate property of Contact
Name:

[Store]=ContactName.Column(1)

but it isn't working. How would I fix this?

Happy Holidays, Al!

Jeff

"Al Campagna" wrote in message
...
Jeff,
No problem...
I've been in contact with a friend from this NG (near Redmond) when I
heard the news about the storm/s in the Northwest. He didn't have power
either.
He had to email from work.
Pretty nasty affair...
Hope your OK, and that you'll get power soon.

I'm still confoosed about the OP's setup, and the necessity for "saving"
any combo column in the situation as I understood it.
So I just ignored the setup and just tried to deal with the upshot of
the problem.

The OP hasn't responded since. I think I scared him off! :-D

Have a good holiday Jeff,
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Jeff Boyce" wrote in message
...
Al

Sorry for the delay -- I live in the path of that quasi-hurricane that
blew through Washington state last week, and still don't have power at
home.

When I responded to the OP, I didn't feel I had enough info to make an
informed suggestion. I was just posing a question about the notion of
(re-)storing a Store Name.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Al Campagna" wrote in message
...
Jeff,
This part of my last post should read...

I assumed that ContactName is a combo with StoreID in Col(0), and
store's (ContactName?) in
Col(1). Col(0) would be hidden, and I assumed ContactName is actually
bound to StoreID.
I'm a bit confoosed about the OP's naming scheme... I would have set
it up this way
StoreID StoreName ContactName
142 Boston John Doe
and then gone for Col(2)... select a store by name, and then
AfterUpdate...
ContactName = OPsCombo.Column(2)

Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Jeff Boyce" wrote in message
...
Al

I was with you up to the part about [Store] being a bound column. If
the data is already available elsewhere, and the OP would use something
like a combobox (with columns) to find the correct store, wouldn't
storing the ID, rather than the text, make more sense?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Al Campagna" wrote in message
...
awach,
It appears that you've posted this question several times. Please
stay with one thread while folks are trying to help. Otherwise folks
will end up offering duplicate solutions, and the "flow" of the
problem won't be clear. Keep all the posts together so responders can
see what the progression has been during the problem determination
procedure.
Also, what does "isn't working" mean exactly.

Try this test... just place a
Beep
in the AfterUpdate event procedure, and update your ContactName combo.
Get a beep when you select an item?

And...
Try this test... place an unbound text control on the form, and give
it a ControlSource of...
=ContactName.Column(1)
Does it display the correct value you want to see from the
ContactName combo?

Your EventProcedure should be run on the AfterUpdate event of the
ContactName combo.

Store should be a "bound" text control

I take it you placed the
[Store]=ContactName.Column(1)
in the form module, and not just in the text box for the ContactName
AfterUpdate event. (sorry but I have to ask)

OK, please answer these very basic questions, and we'll keep
"drilling down" till we figure out why it doesn't work. This is a
very simple process, so I suspect there is something you haven't
indicated in your posts, or something we're not understanding about
your setup, that's causing the problem.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions





"awach" wrote in message
...
I want to have a field [Store] that stores the value of
ContactName.Column(1)
after the user selects a contact name.

I tried making an "EventProcedure" on the AfterUpdate property of
Contact
Name:

[Store]=ContactName.Column(1)

but it isn't working. How would I fix this?