Opening form in text box "afterupdate".

[Daff]

Is this possible? I'm trying to do it at the moment, and it gives errors.

I used the wizard to create a button to do it, and it gives the same error. This is all on a sub-form.

What I want to happen: User enters text into sub-form text box, and after update, another form is launched showing the results of a query run using that information as a search string.

 

[sko]

Tell us more about the error you are getting. It is possible to build a query that gets it's data from a text box on another form. Are you trying to run the procedure after form update or after field update?

 

[asenft]

in the afterupdate code of your textbox put the following.
replace formname with the name of the form you want to open after the text box is updated.


docmd.openform ("formname&quot

Aaron