[forms]!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 03 Jun 2008 12:10 GMT

I've set up a number of forms with filter based on forms in access such as ID
= [Forms]![form]!id. however i have been trying to migrate this the access
project, and this seem to cause an error. can anyone tell me how to get
around this ?

Signature

Greg McLandsborough

Reply to this Message

Vadim Rapp - 07 Jun 2008 18:19 GMT

G> I've set up a number of forms with filter based on forms in access such
G> as ID = [Forms]![form]!id. however i have been trying to migrate this
G> the access project, and this seem to cause an error. can anyone tell me
G> how to get around this ?

Should be forms!form1.form!id

Though, I'd think it should be so in MDB as well.

Vadim Rapp

Reply to this Message

Sylvain Lafontaine - 08 Jun 2008 19:39 GMT

There are many ways of implementing a filter in an ADP project. I'm sorry
to say that but with the information provided in your post, I cannot really
tell you what's the answer to your problem. Taking a look at the previous
posts in this newsgroup could also give you the answer that you are
searching. (Or at least, provide you with some good pieces of information
about ADP in general.)

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

> I've set up a number of forms with filter based on forms in access such as
> ID
> = [Forms]![form]!id. however i have been trying to migrate this the access
> project, and this seem to cause an error. can anyone tell me how to get
> around this ?

Reply to this Message

Greg - 09 Jun 2008 23:52 GMT

sorry about the lack of detail. it was late when I composed the last question.

I am building an ADP Project, which is connected to SQL Server Express. I
have a button on one from which uses a macro to open a second form and filter
it. I have arguments of "Modify Project, Form, ,
[Project_ID]=[Forms]![Projects]![Project_id], Edit, Dialog".

however this returns an error of 2950, and an error message of incorrect
syntax near '!'

I can't see why this is failing. Any help appreciated.

Greg McLandsborough

> There are many ways of implementing a filter in an ADP project. I'm sorry
> to say that but with the information provided in your post, I cannot really
[quoted text clipped - 8 lines]
> > project, and this seem to cause an error. can anyone tell me how to get
> > around this ?

Reply to this Message

Sylvain Lafontaine - 10 Jun 2008 01:29 GMT

Try something like:

"Modify Project, Form, , [Project_ID]=" & [Forms]![Projects]![Project_id] &
", Edit, Dialog"

Also, if Project_ID is not a number but an alphanumeric, then you must
enclose its value between single quotes (and double any in-between single
quote). Finally, I'm not sure that this macro will work if you are using a
stored procedure as the record source of your form.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

> sorry about the lack of detail. it was late when I composed the last
> question.
[quoted text clipped - 30 lines]
>> > project, and this seem to cause an error. can anyone tell me how to get
>> > around this ?

Reply to this Message