Search results

Hi The-Doc-Man You mentioning Queries I will spend a couple of hours going through them and checking to see if I can spot any problems. If not will be rack in touch. Thanks

Hi Gasman Sorry about the gibberish, to start with I have a Products Table with 258 Products entered. When I open the Order entry form I select a Customer from a drop down list, then on the Order Subform I select date order is given then tab to Product which again select from a drop down or...

While using ms access to enter an order why does it add the items sold back to the Product Table ie Product # 1 = Aitch Bone but after saving an order which shows up the Orders Table & Orderdetails Table the Product Table show Product # 258 = Aitch Bone another sale Product # 260 = Aitch Bone...

Hi Minty " IT WORKS" Many thanks to everyone for their input

Hi Larry Thanks for assistance have done as suggested and remove the DoCmd.RunCommand acCmdSaveRecord. line of code. i have tried the "Me.CustomerID = Forms![Form Orders Input]![CustomerID]" code but it did not work, but I have attached a couple of screenshots. Again thanks for your interest.

Hi Minty thanks for keeping in contact as requested am attaching a screenshot of the Control Property on the Order Input & the Customer Input Forms the Control Properties are Identical,

Thanks Everyone will try out all your suggestions hopefully in the next couple of days. Thanks Again

All I can see in Default in Properties is Fetch Default and Option is set to Yes

Yes I can .

I see what you are saying about Autonumber , the record I was / am trying to use is the record just entered via Customer Inp0ut form. Mind in saying all this perhaps its just as well to select from combobox rather than trying to write different code. Thank for your help.

I have checked all across both of the forms I am using ie. Form Customer Details Input : The form itself does not have a Control Source only a Record Source which is the tblCustomers and all the fields on Form have a Control Source from the tblCustomers Form Orders Input : Again The Form...

Hi Again Minty Sorry to be a pain but one unfortunate thing is I have Covid first time and I do feel exhausted , can I come back to you later and in the meantimde I will try to answer all the questions you have put to me. Thanks

Hi Minty I have a drop down Combo Box on the order from but this is unbound and work perfectly well but my object is to enter the new customer details into Customer Details form and keep this information and display it on the Order Form without having to select from the Combo Box. Hope you...

No the primary key in the Orders table is OrderID and CustomerID is a Number

Control is the Primary Key in customers table also an Autonumber

Hi Everyone don't know if anyone can help with the following :- Just entering new customer information and would like to copy this info across to order from which I open from the customer input form and get the error message "Error 2448" (You can not assign a value to this object) The code I...

Hi thanks for code work great. Thanks again Brian (A17BPG)

Hi Thanks for reply's I have tried the "ProperCase" Command with the result (Compile Error - Sub or Function not Defined). The code using : Private Sub txtAddress1_AfterUpdate() Me.txtAddress1 = propercase(txtAddress1, 1) End Sub Thanks Brian (a17BPG)

Hi Everybody I am trying to enter a line of code that allows me to input the house number in a text box followed by the street name, but want the first character of street name to be in UpperCase. Has anyone any suggestions on coding I can use. Thanks Brian (A17BPG)