Calling one form from another

[CD Tom]

Here's my question. I have a form where user can select how they want to edit a customer, by cust naumber, last name there are about 5 different selections. After the user selects the option say the customer number I want to open another form using that customer number as the where clause.
I use the following code to open the form

docmd.openform "EditCust",,stdLink

where the stdlink = custNumber = " & VCustNumber & " When the form comes up it's blank. The forms record source is the customer table. When I look at the forms data it shows the filter as customernumber = the number specified in the stdlink. Any ideas why this is happening.

Thanks

[twinnyfo]

CD Tom,

It's difficult to know for sure what your stdlink is supposed to be. If your post is accurate, it should reflect:

stdlink = "custNumber = " & VCustNumber

But, I'm not sure I'm covering all the possibilities here, as the code on your first form is not provided.

[zmbd]

If TwinnyFo's reply didn't help, then it would be helpfull to see all of the VBA that feeds the line you posted.

[CD Tom]

I figured it out I'm going to use the openArgs to send to the other form. Thanks

[NeoPa]

I would expect the value of stdLink needs to be :

custNumber = 'XXXXXXX'

where XXXXXXX is the actual customer number.

Example Filtering on a Form will give you some tips on this. I would certainly not recommend switching to the use of OpenArgs in this case. It is not more appropriate and is simply an attempt to avoid dealing with a little confusion. That leaves you stuck the next time you want to filter a form properly.