Search results

Brilliant! I really appreciate you spending your time to help vbaInet. Thankyou once again - I will take your suggestions on board - I tend to be overly code verbose at times when less is often more. Cheers, Vince :D

Please see attached, and thanks again for your help

No Luck - same error :(

Something different.. I left the pasing and receiving as is: Call Attachments(Form, Form.PassField) Function Attachments(frm As Form, strFieldName As Control) The only thing I changed was the frm.strFieldName.Name to Forms(frm)!Controls(strFieldName).Value and I get Run-time error 13: Type...

Thanks for your help on this. I am calling the function from a command button (cmdAttachDoc) on a form (called frmLog), which isn’t a subform. Next to the cmdAttachDoc is a bound text control (field) called PassField that I would like the information provided by the function to be stored. I...

Thanks VbaInet, I'm not sure what you mean though. the Function itself is fine varFile has the required info I just can't get it back into the form and field that parametised the called the function. I am sure the The frm (frm as Form) part seems fine and the strFieldName (strFieldName As...

Hi, I am not an access expert and so hope the solution to this may be fairly straight forward. I am trying to return a value gained from a function into a specific field on a form. I have a few fields in which i would like to do this so rather than creating multiple codes referencing individual...