Combo Box not growing with lookup table

[Joe_A]

Hello again, my favorite place to come and get help from.


I have a new problem to me, but it may be old on the forum and I just can find it.
I have a DB that that is growing slowly. To keep it simple I have 2 tables and one form. One of the tables is a “ASSET_lookup” table. The other table (ASSETS) is the real meat and potatoes. I have a form for the assets table that will populate specific fields that are looked up based on a single combo box linked to a query from the assets_lookup table. Everything worked fine until I needed to add some additional items to the asset_lookup table. The new “records I added to the lookup table will not show up in the combo box after it updates (a selection is made). I did some experimenting and if I recreate after adding the new records to look up table, the combo box will show the value, but I am curious what I am missing.

Thanks for you time

[goodguy]

When the form with the combo box is opened, the combo box is populated at that time from its defined record source. If the source table is updated after that, the combo box must be requeried in order to refresh the source data. Syntax:

combobox.Requery

[Joe_A]

When I try to use the requery it gives me an error with some blurb about a possible read only or not the right form.

[Joe_A]

Sorry. I tried that and then realized I may not have asked my question right. The new parts I added to the look up table show up in the drop down for the combo box. However after I select it, the form work as it should meaning the other fields that auto populate based off the combo box value, with the correct information. But the combo box goes blank. This only happens on the part numbers that I added to the table after creating the form and combo box. I did the requery but that did not help. If I create a new combo box the form works fine. crazy.

[goodguy]

That shows that some properties were messed up in the first combobox.

[Joe_A]

Thanks goodguy for your help. I am still unclear what settings could have done this but the work around is fine I just hope I don't have to recreate the box each time I need to add parts to the look table