Search results

Thanks again Mark and Minty! I got it to work by borrowing your ideas and code! Here's the complete code in case someone else runs into a similar situation. It's remarkable how a few stringed sentences can really save us time and energy in our work! Option Compare Database Option Explicit...

I understand the code and I think I can modify it for my needs, but have a basic problem. Private Sub HandleScan() Select Case Left(txtScan, 1) Case "C" 'set location value MsgBox "work!" Case "B" 'set bag value MsgBox "work!"...

Hi Mark, Thanks, good points! You are right about the Textbox.Change event. I was going to go back to that problem after I figured out the other problems :-). Fortunately Minty's code can be adapted to Textbox.Update event for Location textbox which I will do. Let me consider your...

Thanks Minty! Part of the reasoning I want the cursor to automatically move to the Location textbox if text begins with C is to eliminate the need for the user to walk back to the computer and place the cursor in the Location textbox every time the location changes. In other words, the...

Hello, I am pretty new to VBA and mostly figure things out through trial and error and borrowing google-searched codes. I am running into a few problems with what I want to do, found ways around some of these problems, but now stuck.:banghead: I have an Access Form with 3 textboxes: 1. Textbox...