Search results
-
C
multiple table validations
oh by the way, the check boxes are Yes/No data type -
C
multiple table validations
It is linked to a text field and I have the display control as "Combo Box". Row source type is Value List, and in the Row source I typed out the options: Yes, No, Not applicable, etc I just used it in the AfterUpdate event of Tocolytic and it confirmed each selection with a msg box. MsgBox... -
C
multiple table validations
okay, sorry where do I use this messagebox. In the AfterUpdate event? -
C
multiple table validations
the values are the same..? Yes, No, Not Applicable. How do you mean, Use a messagebox? -
C
multiple table validations
um... vbaInet, I saved the code in the Form's BeforeUpdate event but it is not obeying the constraint. It is not prompting me to check a box if either of the combo boxes is Yes and it goes ahead to save the record... -
C
multiple table validations
This makes sense. A million thanks vbaInet for your help and patience:) Might not look like it but I've learnt some from you and this website. I really appreciate it. The thought of taking VB classes is no longer a daunting prospect. You know, I just might just be teaching y'all someday. I say... -
C
multiple table validations
Now without the quotes: Private Sub Form_BeforeUpdate(Cancel As Integer) const string vbNullString Me.chkIndomethacin.Value = False Me.chkNifedipine.Value = False Me.chkNitroglycerin.Value = False If Len(txtOther.Text & vbNullString) = 0 Then txtOther.Text = vbNullString me.cmbTocolytic.text=... -
C
multiple table validations
I'm still trying to figure out though how to code the check boxes. I can't use OR and the ELSE is looking really wrong from here:mad: -
C
multiple table validations
sorry yes. I took the quote marks off but put them in again out of habit, when I was typing. many thanks vbaInet. Okay so in this regard, all this code is going into the AfterUpdate event of both combo boxes then. Since their values' determine those of the check boxes... -
C
multiple table validations
Okay this is the code that I need to clean up. Just don't know how. Please forgive the syntax & programming errors Private Sub Form_BeforeUpdate(Cancel As Integer) const string vbNullString Me.chkIndomethacin.Value = False Me.chkNifedipine.Value = False Me.chkNitroglycerin.Value = False If... -
C
multiple table validations
Excuse my programming inexperience. vbaInet, I reckon that in the Before Update event of the form the controls should be initialised...? This is the code that I have there but it incomplete. The controls involved here (see attachment as well) are 2 combo boxes, 3 checkboxes and one text box. If... -
C
multiple table validations
hm oookay. I'll try that. hopefully it'll work. -
C
multiple table validations
Thanks vbaInet. On the form, that would be in the Change Event procedure...wouldn't it? -
C
multiple table validations
Hi CJ, no it is not working :banghead:. Could you help advise how I can correctly represent the table rule? -
C
multiple table validations
That is the design that was agreed upon and prefer to go with. -
C
multiple table validations
The second seems to be working now. I had my parentheses wrong. This is what I have and it is working. IIf([Oxytocin Infusion - no PPH]="Yes",([Oxytocin Infusion - if PPH]="No" Or [Oxytocin Infusion - if PPH]="Unable to determine"),[Oxytocin Infusion - if PPH]="Yes") -
C
multiple table validations
hey CJ and Plog, to be clear I have attached two files containing parts of the screen. Tocolytic(s) are drugs administered to women in labour. We need to track which ones were given. I have 2 fields for these if either of them is "Yes" then the user has to specify which of the drugs was given... -
C
multiple table validations
Could someone help me please? I have to assign multiple table validations to my table but they are not even working separately. What am I doing wrong here? Any help is most appreciated 1) I have two combo box controls: [Tocolytics] & [multiple_Tocolytics], 3 check boxes and 1 text box. Rule...