Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2012

    Question Unanswered: SubForm cboBox woes - Value dissapears upon form reload requery

    Hey Guys,
    I was hoping someone could give me some insight to the problem I am experiencing.

    I have a cbobox (Vendor) on my main form which filters my cbobox (Description) on my subform.

    In order to acheive this I had to apply the requery to the Description cbobox on the subform's On Got Focus event:

    Requery: Description
    SetValue: [Description], nz(DMin("Contact","FilterVendor"),"")

    This works great until I create a new record and re-load any previous record, which then loads the form with the Description box empty. I assume this is because the requery is clearing out the cbobox. The data however is still stored in the table and loads into the report just fine. I can live with this issue, But I wanted to know what I did wrong and what I can do differently to fix this and prevent myself from making the same mistake in the future.

    I have attached a screenshot as well.
    Can anyone provide any insight?
    Attached Thumbnails Attached Thumbnails ScreenCapture.jpg  

Posting Permissions

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