Awesome!!! Thank you very much!!

Hi Niall,Thank you for your help. The field (TotalDays) I'm having problems with is located on the first page and I'd like it to trigger the number of rows to be displayed on the table located on subform called Admin_Use. Table3, row1. So, in order words, if the number of night on the TotalDays fiel...

Hi Niall,Thank you for your reply. I'm still a bit puzzled as right now I have this code in my calculate field (see below) under the calculated event and I'm not sure how to insert the code you sent me as I keep getting syntax errors. Any help will be greatly appreciated!!!if (HasValue(Nights.FirstN...

Hi,I'm trying to set the rows of an expandable table to follow the calculated value of a field.The calculated field comes from two date fields that calculate the number of days and I want my table/row to expand based on that number..Is is possible? Right now I have a button that does add an instance...

Thank you Bruce!!! Not only I was using the wrong event but also I was placing the code on the wrong field....

Hi,I have a dropdown field (FlatRate) whose rawValue sets/triggers the value & access of another dropdown field (BillStudent) that resides in an expandable row of a table. However, I want any extra instances/rows that are added to the table to inheret the value set by (FlatRate) when adding more row...

Hi,Thank you very much!! it works great!! I do have one more question though, How do you know that the value "41123" is equal to August 3, 2012? I tried to figured out but I couldn't... I just want to know so I can apply it to any date....Thanks a billion!!!

Hi,Thank you for your reply. I'm not familar with the Date2Num function and I'm not 100% sure how to write the sintax. Would you mind helping me? What I need is to write a code that will prevent users from picking a date before Aug 03, 2012. And I also have another date field where I have to apply t...

Hi,You can do the following under the validate event. Also, make sure you do specify item values under the Binding tab of the dropdown field..if (this.rawValue == 1) {    xfa.host.messageBox ("That account Number is not valid.","Invalid Acct Number",0);    this.rawValue = null}

Hi,I need to set a condition on a calendar field (ArrivalDate) that enforces users to only pick certain date from the calendar. Otherwise, it will give them a message and clear the calendar. Also, I need to set up another condition with "in between" but I'm not sure how to set these up.THANK YOU FOR...