Entered data keeps disappearing

[wordsmith]

Hi All,

I've got a form with a series of combo boxes which are dependent on each other, however i keep finding that after ive entered some data and left a record, when i then return to the record, some of the information ive entered has been deleted and the combo box is blank.

I think it must be requerying the combo boxes everytime the record opens but i dont know why, i have only put requerys "OnChange" because that is the only time the dependent combo boxes should be requeried.

Once the info is entered and ive moved on to a new record, i need for it to stay that way when i return to the record and only change again when i edit it.

Help please anyone, its been doing my head in.

Cheers

K

 

[Ethereal]

does all the information have a controll source ? also the "on change" event occurs after every single character you type, so it might not be a good idea to requery there

 

[wordsmith]

yeah all the information has a control source,(should it be the same because they have different control sources)

and do you recommend using the "after update" event? i think i had a problem with that before and that's why i used the "on change" event.

i found with the "after update" event when i made a selection, the next combo box would reflect the selection, however if i then changed the original combo box, the next combo box would retain the original selection and not reflect the new selection

 

[Ethereal]

Post a sample of your problem.... I am having trouble invisioning it

 

[wordsmith]

thanx soooooooooo much, here is the file.

u will see that when u open the downtimes form, there are some records in there, but some of them have empty fields. this shouldn't be the case, they have been filled in, but it always removes the data.

i also find that when i then re-enter the data, it sort of remembers what data i entered the first time around, e.g. if i select a line number, i may relevant machine, or category that i originally entered.

thanx soooooooo much for having a look!!