Cant Navigate

D

DS

When I Reopen an Order Entry Form using a Query (Select) and I pick the
SalesID Number I want the form opens to that record, no problem. The
problem is I can't navigate through the Subform that contains the order
details. It keeps me on the first record even though I see the other
records, What could be wrong?
Thanks
DS
 
D

DS

DS said:
When I Reopen an Order Entry Form using a Query (Select) and I pick the
SalesID Number I want the form opens to that record, no problem. The
problem is I can't navigate through the Subform that contains the order
details. It keeps me on the first record even though I see the other
records, What could be wrong?
Thanks
DS
Click to expand...

Heres the line I'm using.

DoCmd.OpenForm "Sales", acNormal, "", "SalesID=" &
Forms!Tables!TableNum.Column(1), , acNormal

It seems that it's turning the form into a read only form since I can't
navigate nor add records. Is there a way to reopen a record without
this happening?
Thanks
DS
 
D

DS

DS said:
Heres the line I'm using.

DoCmd.OpenForm "Sales", acNormal, "", "SalesID=" &
Forms!Tables!TableNum.Column(1), , acNormal

It seems that it's turning the form into a read only form since I can't
navigate nor add records. Is there a way to reopen a record without
this happening?
Thanks
DS
Click to expand...
Found the problem...It was a statement nested in a subform that was
requerying the kit and koobodle.....
DS
 
Top