Passing a date to a field from a pop up form-again!

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi

Rebecca Riordan kindly replied to my earlier post. but I
had another question! If you read this Rebecca I hope you
can reply! Basically I have a close form command button
already on my pop up form but wanted to know where to put
the code you gave me. Click event of close button? I am
fairly new to VBA hence my ignorance

Hope you can help (or someone else if Rebecca doesnt read
this!)

Many thanks in advance

Chris
 
Chris,
I'd place the code Chris gave you on the AfterUpdate event of the
[datefield] on your pop-up form.
The ONClick for the Close button would work too, it's just a matter of
personal preference. Since the "update my other form" code is related to
the [datefield] on the popup, I'd keep that code with that field's
AfterUpdate.
 
Al

Thank you for your attempt to help with my question. but I
am still confused! Since my pop up form is unbound how
does it "know" which record is receiving the information?
and would it not attempt to change all my records not just
the one i am looking at at the time i call up the pop up
form. Perhaps I am missing something obvious! BTW I really
do need to store this date in my table. otherwise i would
have a straight forward calculated field on my form.
I am appreciative of any further help/advice you can offer

Thanks a lot

Chris
-----Original Message-----
Chris,
I'd place the code Chris gave you on the AfterUpdate event of the
[datefield] on your pop-up form.
The ONClick for the Close button would work too, it's just a matter of
personal preference. Since the "update my other form" code is related to
the [datefield] on the popup, I'd keep that code with that field's
AfterUpdate.
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH



Hi

Rebecca Riordan kindly replied to my earlier post. but I
had another question! If you read this Rebecca I hope you
can reply! Basically I have a close form command button
already on my pop up form but wanted to know where to put
the code you gave me. Click event of close button? I am
fairly new to VBA hence my ignorance

Hope you can help (or someone else if Rebecca doesnt read
this!)

Many thanks in advance

Chris
Click to expand...


.
Click to expand...
 
Back
Top