line# in continuous subform

I created the GetLineNumber Function module on my orders subform, it used to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10816-line-in-continuous-subform.html
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
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
recorders, on the new line, the line# always shows"0", and the category and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10816
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

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

I have got the great answer from Doug Steele, so thanks to him once again.

"whitesnow" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10816
> this continuous form works fine. I mean through the frmOpendetail, the
> 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
>