Subform - first record keeps changing

[Dr_Worm]

I've got a form with a subform, on the form is a dropdown box (Combobox) called status from wich I can select to view projects in the subform. When I select for example "Won" I can see all the projects we have won. When I close and reopen the form the first record from the table where all the information comes from changes status to "Won" (Whatever status was selected from the previous time it was opened).

It only changes the first record in the table, that we know off, hopefully it isn't chaging any other records.

How do we fix this problem?

Also I have been asked how to make it so the form is blank when first opened instead of on the last selected status?

 

[bat17]

At a guess you have the combo's record Control Source bound which is what is causing it to change the records value.

To start with a blank record you could add
DoCmd.RunCommand acCmdRecordsGoToNew
to the Forms On Open Event.

HTH

Peter

 

[Dr_Worm]

Thanks bat17

It works like a charm!

We can't beleive it was that simple

Dr Worm