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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |