vba Forms -- Opening a pop up form from a form to get values and update main form

[Susy]

Hi



I have two tables {tbl_Customer, tbl_Company} and I would like to know how to open another mini form (just to do a search '* keywords *') and once I find the string or text I need, I will just click on it (the value in the mini form) and the value on the main form is updated...

The field "CompanyName" in the mini form is linked to the table "Company", which has all company names

The table Customer contains following fields {CustID, FirstName, LastName, CompanyName, CompanyCity,...}

the table Company contains the following fields {CompID, CompanyName, CompanyCity,...}

Some "CompanyName" fields (from table Customer, are empty or misspelled, so by having a main form and a miniform, I can clean and correct those fields. I want to avoid copy and paste from the mini form.


Regards

[pbaldy]

This could be adapted:

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

adding a search textbox and a combo or list box.

[Susy]

Thanks, but that is not what I am looking for.

I don't know how to transport the value from the mini search form to the main form... to update it with the correct value from the table company.

[pbaldy]

The sample shows how, just imagine a combo or list box instead of the text box.

[Susy]

thanks... I am thinking something more with me.OpenArgs, but I don't know how to send the value to the main form, once I selected the right name of the company from the mini form...

??

me.OpenArgs

me.Recordsource

??

[pbaldy]

You'd use OpenArgs to send a value to the popup. Have you looked at the sample? It gets the value from the popup back to the calling form.

[Susy]

I think I understand you! However, this is something else... I used the same logic with my various databases... DLookup(password, users, password = inputbox)...

Thank you anyway...

[pbaldy]

I guess I don't understand, as I don't see how DLookup() relates to this. I use this method to pop up a form with a list of drivers or vehicles that the user can pick from. It can be called from various places in the app, and passes back the selection to the form that called it.

[HiTechCoach]

I second Paul's suggestion of using the wrapper function with your "miniform".

I use this method to do basically what you are wanting. I prefer to pass back the record ID. I also use it to make a custom InputBox() that uses the power of a form.