By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,735 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

set recordsource to query ==>> error 2467

P: n/a
Hi,
I want to set the recordsource of a subform to a query with this
syntax :
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"

the problem is after typing sub75. I get a list of possilities, but
after form. I don't.. I know nothing about access, so can anybody help
me?

Greetzzz
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
See inline comments:

"Annelies" <an**************@hotmail.com> wrote in message
news:c7**************************@posting.google.c om...
Hi,
I want to set the recordsource of a subform to a query with this
syntax :
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"
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?
the problem is after typing sub75. I get a list of possilities, but
after form.


This is standard behaviour
Fletcher
Nov 12 '05 #2

P: n/a
"Fletcher Arnold" <fl****@home.com> wrote in message news:<bl**********@hercules.btinternet.com>...
See inline comments:

"Annelies" <an**************@hotmail.com> wrote in message
news:c7**************************@posting.google.c om...
Hi,
I want to set the recordsource of a subform to a query with this
syntax :
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"
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?
the problem is after typing sub75. I get a list of possilities, but
after form.


This is standard behaviour


I tried it in 2 ways:
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"
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. Fletcher

Nov 12 '05 #3

P: n/a
an**************@hotmail.com (Annelies) wrote in message news:<c7**************************@posting.google. com>...
"Fletcher Arnold" <fl****@home.com> wrote in message news:<bl**********@hercules.btinternet.com>...
See inline comments:

"Annelies" <an**************@hotmail.com> wrote in message
news:c7**************************@posting.google.c om...
Hi,
I want to set the recordsource of a subform to a query with this
syntax :
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"


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?
the problem is after typing sub75. I get a list of possilities, but
after form.


This is standard behaviour


I tried it in 2 ways:
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"
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.
Fletcher


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...
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.