Creating a form to open up a diffrent form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a form that will have a couple of choices, one will be
a command button to "create a new order" and that will open up a diffrent
form in the "add mode"
and a difrent buttom will have aplace for me to type in an order number and
then I click the button, and it will open that particular order in a "edit
mode". How would be the way for me to program the buttons and do this?
 
To open "frmNewOrder" to a blank record:

DoCmd.OpenForm "frmNewOrder", acNormal, , , acFormAdd

Do open "frmEditOrder" to edit the order whose Order Number equals the order
number you entered into the txtOrderNumber text box control (assuming Order
Number is numeric and not alphanumeric):
:
DoCmd.OpenForm "frmEditOrder, acNormal,, "OrderNumber = " &
me.txtOrderNumber,acFormAdd
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating filtered forms 1
making a form to edit the values of a combobox (how to) 1
Access How Current page of a form Read Only 2
Create multiple reports on the one form 2
Access Access 2010: Activating controls in a form after filter by form 0
Open Orders with matching Order Item Lines from Item form. 2
Pop-up form that creates record that links 1:1 to main form 0
Query about opening an item in a form from the Switchboard 4

Back
Top