No problem Bruce - it's that time of year. No rush. I can see the problem in the code, but that wasn't affecting any of the other items, just the bottom two products in the 'enfit' section - I have no idea why these two are not returning their codes.If you just take a look in your own time it would ...

Sorry - I have changed the sharing to 'anyone on the internet can view'. Hopefully that helps - link below:clinical_orders.pdf - Google Drive

That's brilliant - thanks radzmar!

Hi Bruce,There isn't any special characters (just numerals) and I can't see any duplicates. I've uploaded the form (link below). Just to help, one of the issues is in the 'Oral, EnFit Syringe' section (EnFit ADAPTOR, BOTTLE: MEDICATION, BOT DIA 25.5 - 27MM). Thanks for your help.https://drive.google...

Hi, I have a form with a drop down list containing products - when a product is selected a text field in the same table shows the product code. This works mostly - the only problem I've noticed is when particular products are chosen the code field remains blank. I have no idea why this is happening ...

An 'Email Submit Button' - submit as PDF

Hi radzmar, I want to apply a similar function to a message box. When the user clicks on 'submit' to attach the form to an email I want to ask them if they're sure the form is complete. This is OK if they choose yes, the form attaches to the email, but it also attaches to an email if 'no' is chosen....

Thanks Bruce - that works well.

Hi - I have used code referencing the 'specified values' of the items in a drop down list to hide/show a range of subforms. I want to be able to use the 'text' of the same items to populate a text field. This text field will become the 'subject' line of the email that this form is attached to when s...

Hi, just found this answer. Great tip, exactly what I was looking for. Thanks.