Hi,
Could somebody help me with this please. I have a form that contains hundreds of records, and the user moves from one record to the next checking/inputting data.
I have a Dmax lookup function in the form that calculates a max value for a field when the user makes a selection from a combo box.
The idea being if the value provided to the text box from the lookup function is above a certain value a msgbox will appear to warn the user.
This all works well but then when I go to the next record the value is still in the text box. I know clearing the text box can be done manually with a button, however there is a lot of data on the form and it can be easy to miss. Is there a way to clear a textbox when the user leaves the form, the textboxes in question are unbound
The form is within a NavForm
so Navform-->Form1(accessed on menutab on navform)-->form2 ( accessed by a button from form1)
The 2 textboxes I need to clear on are in form2 (txtbox1,txtbox2)
Is there a simple way to do this when the user moves from one record to the next within form2 design. Sorry if ive not explained that very well.
Its probably simple but been going round in circles with buttons and trying form onload events but they only seem to work when the form is loaded, where as
I want to clear the text boxes when moving between the records in the form. Thanks for any help
Could somebody help me with this please. I have a form that contains hundreds of records, and the user moves from one record to the next checking/inputting data.
I have a Dmax lookup function in the form that calculates a max value for a field when the user makes a selection from a combo box.
The idea being if the value provided to the text box from the lookup function is above a certain value a msgbox will appear to warn the user.
This all works well but then when I go to the next record the value is still in the text box. I know clearing the text box can be done manually with a button, however there is a lot of data on the form and it can be easy to miss. Is there a way to clear a textbox when the user leaves the form, the textboxes in question are unbound
The form is within a NavForm
so Navform-->Form1(accessed on menutab on navform)-->form2 ( accessed by a button from form1)
The 2 textboxes I need to clear on are in form2 (txtbox1,txtbox2)
Is there a simple way to do this when the user moves from one record to the next within form2 design. Sorry if ive not explained that very well.
Its probably simple but been going round in circles with buttons and trying form onload events but they only seem to work when the form is loaded, where as
I want to clear the text boxes when moving between the records in the form. Thanks for any help