Re: Form with subform not refreshing

It sounds to me like you have not set the LinkChild / LinkParent properties
of the subform control properly.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


"Tami" <tami.lipham@xxxxxxxxxxxxx> wrote in message
news:7F078B9A-9571-4DF4-9A20-1F5218B96E6A@xxxxxxxxxxxxxxxx
I have a main form that contains a drop down box linked to my table of
customers. I have a subform that lists all the orders from that customer.

My problem is that my main form retains the last customer looked up and
also
my subform includes my First order record (even though it doesn't belong
to
that customer) and when I choose another customer, my first order record
is
changed to the retained customer.

How do I fix this?
--
Tami


.

Relevant Pages

  • Re: RunSQL Update within DAO
    ... --Roger Carlson ... MS Access MVP ... Access Database Samples: www.rogersaccesslibrary.com ... dim strSQL as String ...
    (microsoft.public.access.formscoding)
  • Re: Removing Dups
    ... --Roger Carlson ... MS Access MVP ... Access Database Samples: www.rogersaccesslibrary.com ... Dim dbs As Database, strSQL As String, strCriteria1 As String, ...
    (microsoft.public.access.formscoding)
  • Re: Percent Syntax not working...
    ... just want SUM. ... --Roger Carlson ... MS Access MVP ... Access Database Samples: www.rogersaccesslibrary.com ...
    (microsoft.public.access.modulesdaovba)
  • Re: QueryDef vs. Recordset Errors
    ... the DSUM function works great. ... "Roger Carlson" wrote: ... MS Access MVP ... Access Database Samples: www.rogersaccesslibrary.com ...
    (microsoft.public.access.formscoding)
  • Re: No Record Error
    ... --Roger Carlson ... MS Access MVP ... Access Database Samples: www.rogersaccesslibrary.com ... ' On Error GoTo Err_ScheduleCB_Click ...
    (microsoft.public.access.forms)