UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Fill in the same order number    
 
   
canett
post Jan 22 2006, 07:36 AM
Post #1

New Member
Posts: 16



I have a continous form where the first control is orderid.It is based on a query.I want however to add other orders.I can do it, if choose another product from the combo box and write down manually the same order number as the previous ones.Can i do it by a code?
For example the first line in my form reads
orderid product
1 productOne
If i choose ProductTwo from the combo box, the control OrderID remains blank.I have to write down the number 1 and then Access accepts my edit.
Can somebody help me ?
Go to the top of the page
 
+
ace
post Jan 22 2006, 09:43 AM
Post #2

UtterAccess VIP
Posts: 5,278
From: Upstate NY, USA



With your setup and without code pressing:

ctrl + ' (ctrl + single quote)

while in the control for order number on the new line will
enter the order number from the previous entry
Go to the top of the page
 
+
Larry Larsen
post Jan 22 2006, 10:11 AM
Post #3

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)



Hi
Welcome to Utter Access Forums

It would be helpful to know a little more about your structure and why you feel the need to duplicate the orderid.
In general a O:M structure & relationship your orderid is created automatically.
If you need an example have alook at the db called Northwinds that shipped with access.
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 02:01 AM