Oh Doh!
I had corrected it to CylinderName before at the urging of a colleague (she doesn't like spaces)... :-/
Thanks so much again June7! You are a champ!
Oh Doh!
I had corrected it to CylinderName before at the urging of a colleague (she doesn't like spaces)... :-/
Thanks so much again June7! You are a champ!
I agree with colleague, as shown by my previous post. Great minds ...!!!
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Once again a big save for me there June7! Man sometimes you just don't see the forest when you stare at trees... or is it the trees when you stare at the forest? Oh well.. thanks again so much.
I had indeed originally named with a space in the variable and changed it later. When I adjusted my code I guess I neglected one of the values. I'm used to using a different program and using the Replace function - I should really transfer my skills over.
Thanks again!
Access will propagate name changes to some degree, but not everywhere.
I use Rick Fisher's Find And Replace for Access. Saved my sanity more than once during db development. Cost about $50.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.