Originally Posted by
John_G
OK. What you can do is assign the job number to the Job Number field on the order entry form when it is first opened, and don't clear it when you do a save. You can prevent users from changing it by setting the "Locked" property to "Yes". If a control (field) is Locked, users can't make changes to it, but VBA can.
No - you'll need it if users are going to enter multiple orders for the same job. You don't want them having to reopen the form for each new order.
One thing you'll need to account for - if a user enters an order, presses "Save Record", and then presses "Save Record" again or presses "Save and Exit", what happens? The save procedure should check that there is data to be saved - you'll have to decide what fields have to be filled in before the record is "Valid" and can be saved.
Actually, the button you don't need is "New Entry". If you clear the data after saving (with the "Save Record" button), then you effectively have a New Entry already.