Hi Guys!
I made a form-subform structure and I began use it. As I put some data in the subform's fields Access started to order them by a certain field.
It wasn't good because I wanted the subform's record be ordered by another field - a numbering field.
(It's VB code:
Me!numbering = DCount("*", "DELIVERIES_DETAILSI", "ID=" & Forms!DELIVERIES!ID) + 1)
So, I opened the subfom in itself, and I set it to be ordered by the 'numbering' field. Then I closed it and opened the main form again.
When I set the cursor on the second record (to enter some data) Access immedietly jumps on the first record making the data-entering impossible.
What could be the problem?
If any idea, please help me how to solve it.
Thanks in advance,
Sz.Cs.
I made a form-subform structure and I began use it. As I put some data in the subform's fields Access started to order them by a certain field.
It wasn't good because I wanted the subform's record be ordered by another field - a numbering field.
(It's VB code:
Me!numbering = DCount("*", "DELIVERIES_DETAILSI", "ID=" & Forms!DELIVERIES!ID) + 1)
So, I opened the subfom in itself, and I set it to be ordered by the 'numbering' field. Then I closed it and opened the main form again.
When I set the cursor on the second record (to enter some data) Access immedietly jumps on the first record making the data-entering impossible.
What could be the problem?
If any idea, please help me how to solve it.
Thanks in advance,
Sz.Cs.
