My Assistant
![]() ![]() |
|
|
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 ? |
|
|
|
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 |
|
|
|
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 Top · Lo-Fi Version | Time is now: 21st May 2013 - 02:01 AM |