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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto populate from combobox producing VBA error

Status
Not open for further replies.

indygirl

Vendor
Nov 1, 2006
35
US
I have 2 forms - a main form and form no. 2 in the same database. The main form has the contact information which the user chooses a selection from the drop down and the text boxes autofill with the correct information. Works great. But when I try the same thing (just with different information) on the next form I receive a VBA error. My code is posted below.

Private Sub QuoteDate_AfterUpdate()
'Update quote information on contact based on quotedate combobox.

Me!QuoteLink = Me![Quotes].Column(1)
Me!system = Me![Quotes].Column(2)
Me!employee = Me![Quotes].Column(3)

The error I receive is:

The expression AfterUpdate you entered as the event property setting produced the following error: Procedure declaration does not match description fo event of procedure having the same name.

I also receive this error with BeforeUpdate as well.
 
How are ya indygirl . . .

Indications are that you have the same event elsewhere. A global search (select Current Project in the find dialog) in VBE for [blue]QuoteDate[/blue] should find the culprit . . .

Calvin.gif
See Ya! . . . . . .
 
Thanks Ace! I do have the another Before and After Event but it is on the main form with a different field. Do I need to fully clarify the 2nd form? If so, how do I do that in VBA?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top