Join Bytes! (Annelies) wrote in message news:<c70c90f9.0310060629.5ee3794d@posting.google.com>...[color=blue]
> "Fletcher Arnold" <fletch@home.com> wrote in message news:<blre3r$ch0$1@hercules.btinternet.com>...[color=green]
> > See inline comments:
> >
> > "Annelies" <annelies_gijbels@hotmail.com> wrote in message
> > news:c70c90f9.0310060032.4c345029@posting.google.c om...[color=darkred]
> > > Hi,
> > > I want to set the recordsource of a subform to a query with this
> > > syntax :
> > > Forms!Form_patient!sub75.form.recordsource="MyQueryName"[/color]
> >
> > Nothing obviously wrong with that - but error 2467 would suggest that
> > Form_patient is either closed or doesn't exist. Where have you placed this
> > code?
> >[color=darkred]
> > > the problem is after typing sub75. I get a list of possilities, but
> > > after form.[/color]
> >
> > This is standard behaviour
> >[/color]
>
> I tried it in 2 ways:
> Forms!Form_patient!sub75.form.recordsource="MyQueryName"
> in another module
> and Form_patient!sub75.form.recordsource="MyQueryName"
> in another form.
> But if Form_patient would not exist, Forms!Form_patient!sub75.
> wouldn't give a list, or am I wrong. Either way, the form isn't
> closed, it's just not the active form, it is underneath another one.[color=green]
> > Fletcher[/color][/color]
I partially solved the problem myself.. I had to set the subform's
source to a random query so it had a recordsource..
Now I have error 2455...
