Update Combo Box after entering new info

[justgeig]

I have a form that uses a combo box to display a name instead of the ID number but that stores that ID number into the appropriate field. The combo box pulls it's list from a table

My question is this: Is it possible to refresh that combo box after using a different form to enter information about that field? Or is it possible to include that different form as a subform and then refresh the combo box after inputting the correct information into the subform?

[pbaldy]

You should be able to requery the combo.

Forms!FormName.ComboName.Requery

[justgeig]

which form event property should I put that under? I tried On Got Focus and it didn't do it

[pbaldy]

Well, that's VBA code so it would go here:

http://www.baldyweb.com/FirstVBA.htm

The appropriate event would be up to your application. Got focus should work.

[justgeig]

Ok, I'm fairly new at VBA but from what I understand, I did that and it didn't work.

Here is what my code looks like on the originating form

Private Sub Form_GotFocus()
    CaptainCombo.Requery
End Sub

this didn't requery the combo box after closing the form that I made to input values into that table. Here is the database I'm working on. The "New Teams" form has a control to open the "New Captain" form. After inputting the data into that form and it's been closed, I want it to update the "CaptainCombo" combo box in the "New Teams" form.
3-on-3 NEW.zip

Edit: I put that same code into the Mouse Move event in the detail section and it does requery that combo box.

[pbaldy]

I thought you meant the got focus event of the combo. I'd try there or in the code that closes the other form.

[justgeig]

Putting it in the got focus event of the combo worked like a charm! Thanks!!

[pbaldy]

Happy to help!

[Monterey_Manzer]

I am interested in doing something similar to justgeig's combo box and I am hoping you can point me in the right direction. I have a form in which my coworkers need to enter data and for PII reasons the table this form corresponds to cannot store names (uploading to SharePoint). We do use an ID number and I have a table in the locally hosted Access database that links the ID and the names but I can't seem to build an expression that will find them for me. Should I approach this via an Expression in the Control Source, a Macro, or some VBA code?

[pbaldy]

I'm pretty sure SharePoint can handle names, but in what situation are you trying to do this? You could have a combo that got both fields from the local table via SQL.

[Monterey_Manzer]

We can't do names for legal privacy reasons. We use a form to enter records into a table that contains specific details including an ID number that links each record to a corresponding person. I have a local table that matches the ID and the name of the person (different fields for first and last). I would like either just a text box or a combo box that matches the ID number entered in the form to the corresponding name in the local table and displays that matching name. I'm just learning what can be done with VBA, SQL, and Macros and I'm not sure which avenue to pursue at this point.

[pbaldy]

I would use a combo where the control source was the field in the SharePoint table (presuming the form is bound to that table). The row source would be SQL that returned the ID and name, the bound column would be the ID field. The combo wizard should walk you through it.

[Monterey_Manzer]

Thanks! This worked wonderfully.

[pbaldy]

No problem, and welcome to the site!