Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form Update (Access97)

    I have a form which is not behaving itself - can anyone help? I have a main Form "FrmMain", with a subform "FrmEpisode". Within "Episode" is a field giving a doctor's name "GPName", which is dependant upon another field, "GPPractice". Criteria for GPName is currently set at "Forms!FrmMain!FrmEpisode!GPPractice!". This works fine, and when items are selected the underlying table is updated. Problem is that when I scroll back through the records, the names in the GPName field cannot be seen unless I then press the F9 button to refresh. What am I doing wrong?

    Regards. Marion

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form Update (Access97)

    Hi Marion,

    Is GPName a combo box? Try requerying it in the OnCurrent event of the subform frmEpisode:

    Private Sub Form_Current()
    GPName.Requery
    End Sub

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Update (Access97)

    It is a combo box. I have a requery set for the After Update Event, but will try this! Thanks Hans.

Posting Permissions

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