Open form with macro

[NVAlice]

I created a macro I thought would look at the field after I selected the option "credit card" from a drop down list then open the form "Credit Card Info" so I could fill in the credit card information. The macro works but I have to put in the words "credit card" in the "enter parameter value" dialog box. I attached the macro to the "after update" in the action property box.

What do I have to do to get the action to work when I select "credit card" for the the drop down list?

Thank you in advance for any help.

NVAlice

 

[Mile-O]

Can you post an example of your database as I find it hard to understand what you mean.

I, and most others here, don't actually use macros due them being, for want of a better phrase, crap - they are nowhere near as flexible as VBA which is what most would recommend using rather than macros.

 

[NVAlice]

I would be happy to post a copy of the database, could you tell me how?

I don't know much about VB so I have tried to use the macros instead. This should be a simple macro I am just doing one small thing wrong. When the value in the field is "credit card" I want the macro to open another form so I can put in the credit card information, ie., cc #, type, expiration date, etc.

NVAlice

 

[Mile-O]

Attachments are described in the forum's FAQ

 

[NVAlice]

Okay, I think I loaded the database as a zip file. I hope this works.

Thanks for your help

NVAlice