Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    61

    Question Unanswered: SubForm Query Issue

    Hail to all. Ok I have a subfor query issue. Here is the query:

    strSQL = "SELECT DummyDCNs.Contract, DummyDCNs.JulianYear, DummyDCNs.JulianDay, DummyDCNs.CameraNumber, DummyDCNs.DummyDCNNumber, DummyDCNs.MemberID, DummyDCNs.DocType, DummyDCNs.DateCreated, DummyDCNs.MailRoomUNumber, DummyDCNs.Cancelled, DummyDCNs.Notes FROM DummyDCNs"

    Me![DummyDCNs subform].Form.RecordSource = strSQL

    Now here's the deal. If I enter the data through the form this query will show that record in the subform. but if I enter the data directly into the table those records will not show up in the subfrom.

    I have even entered a record in the form and then copied the record and pasted it again in the table and it will only show the one record entered through the form.

    Very strange. If anyone has a solution it would be greatly appreciated.

    Mythos

  2. #2
    Join Date
    Apr 2005
    Posts
    61

    I Figured it out

    Ok I found the problem. The sub form was linked to the main form to one of the fields so it was filtering only the records that matched the linked field. I removed the link and all is well.

    Mythos

Posting Permissions

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