Re-open form showing last record (when using a form with a subform)

I think you misunderstood me again

I want to re-open the person form showing the questionnaire that was
edited. I don't want a filter that prevents me from seeing all the
other persons.

Your last code takes me back to where I was. It takes me back to the
specific person but not to the specific questionnaire.

Thanks,

Sergios

Sergios,

The intention of my code is to take you to the specific person *and* the
specific questionnaire, at the same time allowing navigation to other
persons' records. Doesn't it work this way for you? If not, I can't
see why not.

--
Steve Schapel, Microsoft Access MVP


wrote:
I think you misunderstood me again

I want to re-open the person form showing the questionnaire that was
edited. I don't want a filter that prevents me from seeing all the
other persons.

Your last code takes me back to where I was. It takes me back to the
specific person but not to the specific questionnaire.

Thanks,

Sergios

Sergios,

Really, I think the main lesson from all of this is: Don't use unbound
forms.

--
Steve Schapel, Microsoft Access MVP


wrote:
I think you misunderstood me again

I want to re-open the person form showing the questionnaire that was
edited. I don't want a filter that prevents me from seeing all the
other persons.

Your last code takes me back to where I was. It takes me back to the
specific person but not to the specific questionnaire.

Thanks,

Sergios

Well to be honest I tried not to use an unbound form, but I had some
problems and I was adviced to use it. And it worked really good, except
this issue which I think is not a big deal.

Anyway I really appreciate all your help. I will leave it as is for
now. If I have some "insipiration" in the future maybe I will try to
fix this.

Thanks again,

Sergios