Restrictive ComboBox

U

Utopian®

Hello everybody!

I need this precise:

I have 2 Forms, one "initial" and another "Secondary 2"..... In the "initial" there is a ComboBOX (with the code above) in which I choose a "City"... this does that it loaded the "Secondary 2" form just by the data pertaining to the chosen city.


--------------------------------------------------------------------------------

Private Sub choose_AfterUpdate()

DoCmd.OpenForm "Secondary 2", , , "[idCity]=[forms]![initial]![choose]"

End Sub

--------------------------------------------------------------------------------


Now, which I need is: That when choosing this city once, no longer is possibility of returning to choose another one in the next load.

I hope to have been clear, and sorry for my english!!!

Thanks in advance,

Adrian.-
 
Top