Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    UK
    Posts
    15

    Unanswered: After update refresh?

    Hi,

    I have a combo box on my form, when you select an item from the combo box it performs an after update, populating some text boxes with information on the item selected;

    (AFTER UPDATE ON COMBO)
    Private Sub Combo200_AfterUpdate()
    Me.Text146 = Me.Combo200.Column(2)
    Me.Text157 = Me.Combo200.Column(3)
    Me.Text160 = Me.Combo200.Column(4)
    Me.Text162 = Me.Combo200.Column(5)
    End Sub

    This all works fine, however, when I go back to view a previous record all the information in the text boxes have disappeared. If I reselect the item from the combo box it all comes back again. Is there a way for the text boxes to keep there information, or for the after update command on the combo box to be refreshed each time you navigate a record??

    Thanks in advance

    Steve

  2. #2
    Join Date
    Jul 2003
    Location
    Italy
    Posts
    139
    Try to put the same code on the 'on current' event... I don't know if it'll work. The problem is that probably the other text box are bound to a table or the form itself has a datasource. It might be an idea to create a subform unbound just for the text boxes.
    Marco
    ---Do not send e-mail---
    "New Big Bang Theory: God said unzip universe"

  3. #3
    Join Date
    Jun 2003
    Location
    UK
    Posts
    15

    Smile

    Thanks, thats done the trick!

    Thanks again.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •