Best way to pull a "StoreCode" into a field, and insert that into a table

[snipe]

Hey,



I have a form for payroll for the 16 assistant managers in my company. This form inputs 16 different fields into a table, and then calculations are done from that data.

HR will click a combo box to pick which manager they want to enter data for. There is a store code as well (01 through 08). I want that store code to auto-populate after a salesperson is selected. That value also needs to get inserted into the table.

What is the best way to go about this?

I am perfectly fine with macros or VBA

Also: the employee data gets pulled from ODBC

[ItsMe]

In the AfterUpdate event of the Combobox you could use Dlookup or another method to get the store code

[June7]

If you need to permanently save the store code in the record because personnel can move around, that will require code.

As ItsMe suggested, use the AfterUpdate event of combobox to set value of field.

Include store code as a column in the combobox RowSource and refer to that column by index. Index begins with 0. Column 1 is index 0, etc.

Me!StoreCode = Me.combobox.Column(x)

[snipe]

I am using a text box as the control for the store. (should I?) Whats the vba command to change the value of it to the dlookup value?

[ItsMe]

Where is the value, "store"? Can you include it in the combobox's recordset?

[snipe]

Ok June7, I did that. Technically, it works.

But the field only updates when the user clicks into the store code field (which I plan to have locked and disabled). I have the code in the After Update event on the combo box.

Ideas?

[snipe]

Where is the value, "store"? Can you include it in the combobox's recordset?

Yes, and it actually was already in the combo box due to the box being sorted by store, then last name. I didn't even think to just grab the value from there. But I am still having a small issue. See my previous response.

[June7]

The code works fine for me.

If you select combobox item by mouse click the code should trigger right away.

If you type into the combobox the code won't trigger until leave the combobox by tab, enter, or mouse.

[snipe]

The code works fine for me.

If you select combobox item by mouse click the code should trigger right away.

If you type into the combobox the code won't trigger until leave the combobox by tab, enter, or mouse.

I was clicking. I deleted the store code field and remade it. Works like expected now. Not sure what residual code/crap I had on that text box after all of my attempts.

I appreciate the help guys!