Pop-up Forms

[googalabosh]

I have a database that tracks my customers and the projects they request. I currently have created a form with my customers information and inserted a subform that shows a list of every project I'm working on for that customer.

Here is what I want to do:
I want to remove this subform and turn it into a button I can click that opens a new window with a list of that customers projects. I want to be able to edit (edit, remove, and add) the projects for that customer.

What I have tried so far:
I tried adding a button that opened the subform but instead of just showing the projects for that customer, it shows all the projects for all my customers.

Any advice on how to do this is greatly appreciated. The only knowledge I lack is Visual Basic and Macro's (I know..."only" is a strong word).



TIA for all your help.

-Justin

[pbaldy]

This should get you started:

http://www.baldyweb.com/wherecondition.htm

For new records, you can grab the customer from the main form, or pass it in OpenArgs.

[googalabosh]

pbaldy,

I don't know VBA. I get this is code but I have no idea where to put it and how to set it up.

This should get you started:

http://www.baldyweb.com/wherecondition.htm

For new records, you can grab the customer from the main form, or pass it in OpenArgs.

[pbaldy]

Does this help?

http://www.baldyweb.com/FirstVBA.htm

[googalabosh]

Very much! Thank you. I'll let you know if I'm successful.

[pbaldy]

Happy to help!

[googalabosh]

I'm failing.

Here is what I have but it keeps saying there is an error:

DoCmd.OpenForm "[Projects]", , , "FieldName = [CustomerNumber]" & Me.CustomerNumber

Does this look right?

Happy to help!

[pbaldy]

More like:

DoCmd.OpenForm "[Projects]", , , "[CustomerNumber] = " & Me.CustomerNumber

[googalabosh]

Still no luck. Keeps telling me the form name is wrong. I've tried "Forms![Projects]", "[Projects]", "Projects", "_Projects".....what else is left?

More like:

DoCmd.OpenForm "[Projects]", , , "[CustomerNumber] = " & Me.CustomerNumber

[pbaldy]

Can you attach the db here? I'd expect "Projects" to work, presuming that's the name of the form.

[googalabosh]

I wish I could. Unfortunately, it's proprietary. The company won't allow me.

Can you attach the db here? I'd expect "Projects" to work, presuming that's the name of the form.

[pbaldy]

If it's complaining about the name of the form, the name must not be correct.