Viewing a report from a form

[SASHA_D]

Hi everyone,

I'm having trouble running a report from a form...
I have a command button which the user can press to view the report. In the on click event I have the following....
DoCmd.OpenReport "rptPipsCascade", acViewPreview, , "FFS Code =" & Me.FFS_COde

When I press the button is says 'run type error 13' Type mismatch

Can anyone help me with this?

Thanks!

Sasha

 

[Autoeng]

DoCmd.OpenReport "rptPipsCascade", acViewPreview, , "FFS Code =" & Me.FFS_COde

Have you made a mistake where indicated in red?

 

[SASHA_D]

Hi,

I didn't think so-I used the me.bang and then just tabbed the name from the list.

Sasha

 

[Autoeng]

Check the capital "O" just to make sure.

 

[Autoeng]

This from Access help but I don't think it's your problem.

I'm getting a type mismatch message.
Verify that the criteria you specified is for the same data type as the data in the underlying table or query. For example, the field ReorderLevel has a Number data type. Therefore, if you type the criteria "50", you'll get an error because Microsoft Access interprets values in quotation marks as text, not numbers.
Other situations that cause a data type conflict include:

You're specifying criteria for a Lookup field and the criteria uses the values that display on the lookup list instead of their associated foreign key values. Because the foreign key values are the values actually stored in the underlying table, you should use them when you specify criteria for a field. For more information about Lookup fields, click .


You typed the dollar sign ($) in criteria you specified for a Currency field. Remove the dollar sign, and then view the results.
Verify that the data type of each pair of joined fields in the query is the same. If not, change the data type of one of the joined fields to match the data type of the other. For more information, click .

 

[SASHA_D]

Hi there,

Thanks for the reply.

I checked the capital O-it appears like this in both the report and the text box on the form.
I did have a look on the help file and it didn't really offer any clues-the field on the report and the form are both text etc.

Still puzzled!

thanks,

Sasha

 

[Autoeng]

Can you zip and post the db? Most prefer A97 format.