Full Version: Fill in the same order number
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
canett
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 ?
ace
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
Larry Larsen
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.
thumbup.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.