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  

Unhide fields and make it "required" on basis on text box update



 
 
Thread Tools Display Modes
  #11  
Old November 28th, 2005, 05:15 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Unhide fields and make it "required" on basis on text box update

So where do I insert Call txt2_AfterUpdate ? Sorry, but this may look
stupid to you. I am not getting it though

  #12  
Old November 28th, 2005, 05:15 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Unhide fields and make it "required" on basis on text box update

So where do I insert Call txt2_AfterUpdate ? Sorry, but this may look
stupid to you. I am not getting it though

  #13  
Old November 28th, 2005, 05:29 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Unhide fields and make it "required" on basis on text box update

Your 3rd reply was:
| Sorry to bother Allen, but the txt2 us updated on the basis of
| a combo selection, should i do an afterupdate for the cbo ?

Therefore I assume that you need to use:
Call txt2_AfterUpdate
in the AfterUpdate event of the combo that updates txt2.

Before you do that, make sure you have the code working, i.e. check that you
get the desired results when you update txt2 manually by typing a value into
the field.

Once you have that working, and the combo's AfterUpdate as well, you may
also need to add that line to the Current event of the form, but please take
it one step at a time. Otherwise it's too difficult to debug.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
oups.com...
So where do I insert Call txt2_AfterUpdate ? Sorry, but this may look
stupid to you. I am not getting it though



  #14  
Old November 28th, 2005, 05:59 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Unhide fields and make it "required" on basis on text box update

Thanks Allen, I am getting it if I manually type it into the txt2 box,
but no matter what I do, it is not happening any other way, if I place
it on after update of the combo, or even put it on form current.

Regards

  #15  
Old November 28th, 2005, 06:03 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Unhide fields and make it "required" on basis on text box update

Okay: if it is working when you type into the box, the code is working.

Now, is that combo itself updated programmatically?
Is it's AfterUpdate event actually firing?
Can you add this line to the event procedu
Stop
and then press F8 to step through the code a trace what's running?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
oups.com...
Thanks Allen, I am getting it if I manually type it into the txt2 box,
but no matter what I do, it is not happening any other way, if I place
it on after update of the combo, or even put it on form current.

Regards



  #16  
Old November 28th, 2005, 06:06 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Unhide fields and make it "required" on basis on text box update

Hi I am sorry for all the trouble Allen, I got it. Finally realised
that the combo which I used for after update was linked to an another
combo, so I am now getting it okay.

Thank you for the help !!!

 




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
Add New Field to DB Karen Database Design 7 October 19th, 2005 08:03 PM
Ideas On Producing Envelopes & Labels For Data RNUSZ@OKDPS Setting Up & Running Reports 0 April 28th, 2005 03:22 PM
Combo Box (1st) Populating Text Box (2nd) Field AccessRookie Using Forms 1 April 6th, 2005 11:37 PM
Combo Box & Text Box AccessRookie Using Forms 3 April 6th, 2005 11:33 PM
Must # of fields in the 2 tables in an Append Query be equal? CreativeImages Running & Setting Up Queries 3 October 1st, 2004 05:16 PM


All times are GMT +1. The time now is 05:27 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.