My brain has turned to slush and for the life of me cannot work out what code I need to glue together to get round this problem.
An image is provided to help explain my issue:
The form is used to automate data entry to defined areas of a report using DocVariables.
Waste procedures was very simple to deal with because all that was required was to finish off a sentence within the report. This was achieved using a simple if statement:
Code:
If MemoForm.WPOptionSkip = True Then
ActiveDocument.Variables("WasteProcedure") = "skip provided."
Else
ActiveDocument.Variables("WasteProcedure") = "wait and load waste transport provided."
End If
Equipment schedule is fucking me right off.
I am not looking to be spoon fed a solution, instead it would be useful if someone could offer advice on the right path to take, whether it be using a fuck load of 'If', 'ElseIf' statements, or whatever. My programming experience is practically zilch with the exception of HTML and CSS, so my VB knowledge has only been accrued by reading through other bits of code within this project. However there is plenty of spare time available at work for me to learn something new, so with a little prod from a knowledgeable member, I can start trying to work it out for myself
Any help is GREATLY appreciated. If I am failing to explain myself clearly please flame away and then ask questions.
Social Networking Bookmarks