Command buttom

C

Carol Shu

i created a command buttom "cmdCustomers" in the main form "frmInventory", I
like to write a code "on click event" to help me go to another forms name
"frmcustomer", not sure how to write the code, please help, many thanks.
 
A

Arvin Meyer [MVP]

The code should be the same except you substitute the new name for the
button, the form, and if you have criteria for the CustomerID. The important
line of code would look something like:

DoCmd.OpenForm "frmcustomer", , ,"CustomerID =" & Me.CustomerID
 
H

Hooker DBA [MSFT]

Arvin should not be trusted; he believes that the only appropriate use
of Access is to use MDB / MDE files.

I mean.. that cry baby needs to lose the training wheels
 
Top