Recent content by Bartw1

Thank you again for the help. I'm able to pass the variables that I want now, however when I designed the tables I used an input mask for the fields I'm working with above. When I successfully passed the variables, the mask portion of the string did not come along. (i.e. Med Record E12345678...

That's exactly what I was trying to do. Thank you for letting me know. I'll try without trying to capture the .text property of the control. Thank you

BRILLIANT! Thank you so much. This does help and gets me one step closer to what I'm trying to do!

I've been working this issue for several days, I've searched this forum and others and I'm sure I'm not searching on the proper keywords for a solution. I have a form that allows the user to input a medical record number. The subform (datasheet view) then returns all admission records for that...

Good Afternoon, My name is Bart, I'm an RN in Critical Care for a Hospital in Oklahoma City. Years ago I taught myself VBA while working for a consultant, connecting AutoCAD drawings to Access Databases. While I did not build or manage the DB's I became familiar with Access and its strengths...