vba change string value from a (subform in a form) by opening a pop up form with correct values

[Susy]

Hi there,

I have this subform in a form and a "field" in this subform might oft contain wrong data.

I also have a table with correct matches to erroneous data for this "field" in the subform.

I would really like to be able to click on this field (datasheet view) from the subform and open a search form (with the data from this "correct" table) and select the value which could be or is the correct one, and then update this field in the subform.

Am I making any sense?

Regards

[ranman256]

you cant make this field a combo box, where the choices are from the table?
allow any value entered, but you can still pick from the list.
thus eliminating the extra form.

[Susy]

Yes, I thought about this, the issue is that I am importing data and doing some modifications... plus, the search function from a combobox is not really efficient, especially if the string is long and it contains many words...

we make our lifes complicated, right!

I guess I will keep experimenting... still open for some tips or code...

[aytee111]

Have a button on the subform. On click, open a popup/modal form with a list box of all valid entries. On double-click, close the form and set the field on the subform to the value selected.

[Susy]

that is exactly what I am looking for... do you know how? That will be awesome!

[aytee111]

What part are you struggling with? Ask specific questions.

[Susy]

I will upload an example with what I have worked on until now... :-) then you will see!

[Susy]

Here is my sample database....

The idea is that after the data has been imported and saved in a table, one can open it and look through the values (hyperlink) and those values which are wrong can be updated by clicking on them and then looking for the correct values.

Another thing I am not able is to select the correct value from the list box by clicking...

And updating the value in the main form.




Some thoughts, ideas, references, code???

[aytee111]

Your tables aren't normalized, you need to carry the WorldID instead of the Region on your table. That requires that the changes need to happen on your import procedure, not after the table has been populated.

[Susy]

Hi aytee111, thanks for your comment. I know, I just did it like that as an example.

Even if I do it like that so I can use OpenArgs (with the WorldID), I still don't know how to transport the values between the form and I still don't know how to select the correct value from the list.


(I just open the file you attached... it looks very professional and the code is pretty cool, but, how can this help me...?)


Anyhow, thanks...


If anyone else has an idea, it will be great.