Search results

Hi Wiremonkey22, Thank you so much for you advice! The first part of jump works perfect but the second part of locking the field under a certain condition still cannot be used. Could you help tell me the way out Private Sub v2_AfterUpdate() If Me.v2 = 1 Then Me.v3.SetFocus Else...

Hi listers, I'm very new to Access but assigned to create an entry form with some logics on entry. Would much appreciate if any one could do me a favor to tell me how to: 1/ Jump to a certain field if some other field(s) meet a criteria ie. if age>=45 & sex=2 (female) ==> Jump to Q3 2/ Block...

Fantastic Dear Ajetrumpet, It works like a charm! Thank you so much for your patience & kindness. I will definitely buy book and get to learn more about Access. It's really interesting. Thanks once again, TH

Big Thanks Thanks a lot to Ajetrumpet & Rabbie! It's a bit silly & troublesome to ask this but since I'm totally new to Access & hence don't know how to use the code Ajetrumpet recommended. I would be grateful if you could be show me a bit more specifically how to use it. So indebted to all...

Logic check on entry So sorry for not being clear enough! I want to check the relationship between fields/ variables for the same record right from the entry. The example as follows: 1/ If field "Age"=18 ---> jump to field "smoking" [skip any question in between]; 2/ If filed "drinking"=yes...

Dear experts, I'm quite new to Access but find it very interesting to learn more. I used to create data entry in other softwares but now like to use Acesss instead since it has many advantages i.e can be used for web survey. My question is how to create the routing/ jump & how to check the...

Entry validation & routing ..........