fHelp please-----How to save new data through a command button

[imrosie]

Help please,

I have a customer information form (in an Order app). The old customer information is populated into the controls from row query. However, when I attempt to save new information typed into the controls.....it doesn't work. I have a command button for this event.

Private Sub cmdAdd_Click()
 DoCmd.RunCommand acCmdSaveRecord
End Sub
 

Instead of saving the customers' new info, it's saves a whole new record for the customer....Help Help...what am I doing wrong....anyone
I'm a newbie,,,,,what am I missing here? thanks

[missinglinq]

How does it not work? Does it simply do nothing or does it throw an error? How are you determining that it's not saving the data?
Is the Form's AllowEdits Property set to Yes?
Is you Form based on a Query or a Table?
If based on a Query, can you run the Query and edit the information in it?

Linq ;0)>

[imrosie]

How does it not work? Does it simply do nothing or does it throw an error? How are you determining that it's not saving the data?
Is the Form's AllowEdits Property set to Yes?
Is you Form based on a Query or a Table?
If based on a Query, can you run the Query and edit the information in it?

Linq ;0)>

Hi linq,

Yes the AllowEdits is set to Yes
Yes, my form is based on a query
Yes, I can run the query an edit the info...

What happens is this. I have a search form ,to locate a customer from the Cust table. Once customer is located, it populates their info into all the controls (address, phone, city, etc plus their account number (from an autonum, but that's another problem)....
From there I have a cmd button that opens the 'beginorder' form and passes cust data from search form to the 'beginorder' form
Now when I add the products (from the subform on the 'beginorder' form) and click the save button, a new customer is saved with a new autonumber. This is annoying and I"m trying to figure out how this is happening.

thanks
Rosie

[missinglinq]

What's the code behind the cmd button that opens the 'beginorder' form?

[imrosie]

What's the code behind the cmd button that opens the 'beginorder' form?

Hello missinglinq,

the code is as follows:

Private Sub BeginOrder_Click()
DoCmd.OpenForm "Add an Order and Details"
'The event to open the Order form with some controls filled in
Forms![Add an Order and Details]![thefullname].Value = Forms![Search a Customer]![FullName]
Forms![Add an Order and Details]![TheCompany].Value = Forms![Search a Customer]![compname]
Forms![Add an Order and Details]![custacct].Value = Forms![Search a Customer]![custaccts]
Forms![Add an Order and Details]![ShipAddress].Value = Forms![Search a Customer]![ShipAddress]
Forms![Add an Order and Details]![thecountry].Value = Forms![Search a Customer]![acountry]
Forms![Add an Order and Details]![ShipCity].Value = Forms![Search a Customer]![ShipCity]
Forms![Add an Order and Details]![BillingAddress].Value = Forms![Search a Customer]![BillingAddress]
Forms![Add an Order and Details]![ShipStateOrProvince].Value = Forms![Search a Customer]![ShipStateOrProvince]
Forms![Add an Order and Details]![ShipZIPCode].Value = Forms![Search a Customer]![ShipZIPCode]
DoCmd.Close acForm, "Search a Customer", acSaveNo
 

thanks for any suggestiions
Rosie