We do contractor billing. I have a form. It is populated by a query which grabs only the Contractor Uninvoiced line items from the Materials Purchased (for each Contractor job) Table.
The form opens up in continuous mode, but only one record fits on the screen at a time. If I hit the "EOF" on the bottom of the screen I get all blank fields which IF I fill in - then they get added to the materials table asa new record. That part is working.
My question, what IF I just want to change one of the fields on ONE OF THE EXISTING "OPEN" records which are already in the table.
Right now, I am lost how I would update one of the existing records which I can scroll thru.
The form opens up in continuous mode, but only one record fits on the screen at a time. If I hit the "EOF" on the bottom of the screen I get all blank fields which IF I fill in - then they get added to the materials table asa new record. That part is working.
My question, what IF I just want to change one of the fields on ONE OF THE EXISTING "OPEN" records which are already in the table.
Right now, I am lost how I would update one of the existing records which I can scroll thru.