Ok, I'm having an issue trying to insert a contacts' last name, first name and phone number into the parent form.

If you were able to open the db, when double-clicking on "frmTask", at the bottom there is a Listbox called "Pick-Up Contact" / List87 respectively. When you double-click on that list box, it'll open the form, "frmSearchContact". Here a user can search for a contact name and phone number to call when the task is completed and ready for pick-up by the originating organization. THIS WORKS FINE, even returns the results and all.

What I'm trying to do is when the user searches for someone, like if you type in "T", it'll pull up a contact name, when the user finds the person needed, they then will double-click on it in the list box on that form, "frmSearchContact", this will then input the LastName, FirstName, Phone of that particular contact into the listbox on the parent form, "frmTask".

That's what I can't figure out.

Thanks for the help,

B

Here is what you do.

Create a query that gets the first name, last name and contact info you want, then create a continuous form to display it. Then in the criteria field of the last name field in the query, put this:

Like [Please enter the first few letters of the contact's last name"] & "*"

Then create a button on the main form that says "Search for Contact by Last Name" that opens the continuous form. When this is clicked, the parameter prompt will fire from the query, and that will pop up asking for the first few letters of the contact's last name.

In the coninuous form, put a button in the detail section (when the form is run there will be a button for each record) that says "Use this Contact information" or something like that.

Then on the On Click event of the button on the continous form, put something like this:

Public sFirst, sLast, sPhone, sContact As String

sFirst = Me.FirstName
sLast = Me.LastName
sPhone = Me.Phone

sContact = sLast & ", " & sFirst & ": " & sPhone

[Forms]![frmYourOtherForm].[Contact] = sContact

DoCmd.Close

This will post the contact info to the originating form (which should still be open) and close the continuous form.

Did that work?



mmcdonal

I got it to work! Had to make the "ContactID" field show on the main form, then set the 'double-click' event on the list box to open the search contact form. Ran a query for the list box to search using the data entered into a text box. Then set the double-click property of the list box on the search page to push / pass the information (ContactID [pk]) back to the main form's ContactID field. Then the property of the list box was set to a query to pull the first name, last name and phone of that contact ID back into the field.

Works like a charm!