Edit form problem

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

I have a MasterData form on my main switchboard that is
set to open up in Edit mode, on that form there is an
unbound combo box that allows the user's to enter the
file number and that record will appear.

The problem I'm having is that the file number and data
for the previously entered file comes up when you click
Edit Form on the main switchboard, is there a way to clear
the form so that after information is edited a clean blank
screen will appear.

Thanks.
 
It sounds as if you are hiding the form rather than closing it between uses.
Depending on how you are calling the form and the filter, requerying the
form or reapplying the filter as you activate the form may do what you want.
 
I'm not sure if the form is hidded, when the user click on
the option to Edit Form on the main switchboard, this
launches a macro that opens the MasterData form in Edit
mode. When the form opens it shows the information for
all the fields, it automatically goes to the first record,
what they would like is for it to open to a blank record
instead of the first record, they can plug in the file
number in the Find File Number combo box and that record
appears, I'm not sure if there is a way so that in edit
mode it opens to a blank record. Thanks
 
You could unbind the form, this would allow it to open with no records
showing. Then, when you select the record you want you would set the Record
Source for the form along with any filters. The combo box's Row Source won't
be affected by removing the form's record source.
 
Back
Top