Part of a Value of a Field = Value of Another Field

[June7]

A general module is a code module not associated with a form or report. You can create a general module with the VBA menu Insert command.



The code does call txtCity_AfterUpdate from txtInfo_AfterUpdate.

'Does not work' means what - error message, wrong results, nothing happens? Since it is from your db, it really should work. I didn't modify anything else. Make sure the event properties still have the [Event Procedure] parameter.

[zashaikh]

I see. And I need to insert the code you provided into a general module as opposed to the vba specifically associated with frmLocation?

And sorry. I think I see where the code does call txtCity_AfterUpdate

And sorry. By "does not work" I mean that the txtState is still not being filled in. I do not get any error message. It is as though the code is not recognize txtCity is being called.

[Event Procedure] is still present.

[June7]

No. The code goes behind the form. As I said, all I did was modify the procedures you already had in the db you uploaded and it all works. (Except I did set the state label visible) Suggest if you are not using the same db, then do so to replicate results.

I was merely describing what a general module is and how to create and how to run the debugger.

[zashaikh]

It worked! The problem was I wrote one of the names of the fields incorrectly. But everything is fine now. Thank you so very much for all of your help!