Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Event Triggering

Status
Not open for further replies.

jwalz

Programmer
Oct 31, 2000
78
US
I am trying to populate the contents of a catalog form with the select record from a separate Search form. I am already able to lookup records on the catalog form using VBA code in the AfterUpdate event on a combo box. Is there a way using code to trigger the catalog form's AfterUpdate event from my search form? I have tried createing a dummy field that can act as the catalyst after I SetFocus to it, but I get an error message stating that I can't set focus to that control right now.
Does anyone have any other suggestions?
Thanks,
Janet
 
Janet!

Can you please elaborate a little more on what you want to do, I am not clear.
 
I will try :)

I have a form that allows my user to look up a part from a giant catalog of information. They can find the part that they need from a pull-down on the catalog form, but only if they know the part number. I have added an additional form that can be launched from the catalog form to allow them to search for a part based on other criteria such as description or manufacturer. The search form works just fine. My problem is in communicating the part number selected from the search form back to the catalog form and then displaying the selected part. I can't figure out a way to get the catalog form to go to that record and display it. I was hoping that I could put the selected part number into the pull-down field on the catalog form, and then trigger that field's AfterUpdate event from code on the closing of the search form. Does that make any more sense?

Thanks for your help,
Janet
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top