Form Problem!

[kbrown6915]

Hello, I am currently have users entering work orders into a database. I have added a button to the switchboard which is linked to a form which contains about 15 fields. What I am trying to do is have the data entry person enter in about 5 fields that will remain constant until they exit out of this form, the other 10 will change for every work order. The 5 variable fields will change probaly about every 10 work orders so they need to be able to reset the five fields every few minutes. I am trying to save them some keystrokes. I just what the database to ask which values to enter into the 5 fields and then keep those settings until the form is reset. Thanks!

 

[aleb]

Create five ubound fields in the header of your form. The fields where the information from the ubound fields will go make invisible.
In the properties of the invisible now fields set the DEFAULT VALUE = YourUnboundFieldNames
In the properties of your unbound fields "ON CHANGE" add code me.requery

See example.

 

[kbrown6915]

Form Problem

Thanks for the reply. The only problem is when it requeries it assigns a new work order number every time. It matches the fields up correctly but when you tab out of the field it assigns a new work order every time. I need it to accept all of the constant fields before assigning a work order number.

Thanks

 

[trucktime]

Default

You can assign the values of the 5 fields to variables, just before you go to a new record, and then assign the values of the variables to the corresponding 5 fields as soon as you open the new record.
You can put a command button on the form that clears the 5 fields when needed.

 

[kbrown6915]

Thanks, I ended up just creating a form that pops up before the original form that requires the user to enter the constant fields. Then set the main forms field default value to the field that were previously entered.