I created the GetLineNumber Function module on my orders subform, it used to
working fine. The fields include Line#, product, UnitPrice, Qty, Discount and
ExtendPrice. Then I added a new field Category into the subform. The category
and product are linked by the synchronized combo box, the linked combo box on
this continuous form works fine. I mean through the frmOpendetail, the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10816-line-in-continuous-subform.html
selection of category and corresponding product work fine and the selections
are all visible in the subform. But, the problem is that I can not add new
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10816
recorders, on the new line, the line# always shows"0", and the category and
product field shows” error".
Please kindly figure out what I am doing wrong.
The 2 references I used to build this subform are
http://www.fmsinc.com/free/newtips/a...ccesstip16.asp http://support.microsoft.com/default...NoWebContent=1