Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pl626
  • Order by date
  1. pl626

    recover data after accidental diskpart clean

    I was in the process of turning my USB drive into a bootable drive, when I selected the wrong disk and ran a CLEAN command. Fortunately, the disk was not a system disk ( I have three system partitions on two physical disks-WINXP SP3, Vista Ulti and 7 Ulti). I was in the Windows 7 OS when I...
  2. pl626

    subform requery macro doesn't work in main form

    Duane, thx so much. You were absolutely right. Once I qualified the SQL in the bound queries to use the mainform.subform, it works like a champ!
  3. pl626

    subform requery macro doesn't work in main form

    Sorry, I meant to say the Row Source for the first CB is a query called 'qry_cnx_primary', the second CB has a Row Source from a query called 'qry_CNX_secondary' and the third CB has a Row Source from a query called 'qry_CNX_tertiary' The secondary SQL is: SELECT [CNX Codes].[MSN Abort...
  4. pl626

    subform requery macro doesn't work in main form

    the rowsouce in the sf is a query called 'qry_cnx_primary' and the actual SQL is: SELECT [CNX Codes].[MSN Abort: Primary] FROM [CNX Codes] GROUP BY [CNX Codes].[MSN Abort: Primary];
  5. pl626

    subform requery macro doesn't work in main form

    Duane, I thought the main form subform control name might be the problem, but it's not. I'm assuming by 'Source Document' you mean 'Source Object'? In my case, the SO is 'sf_AIRCRAFT_FLT_LOG' while the 'Name' is 'AIRCRAFT_FLT_LOG Subform'. On the subform, I have 3 Combo Boxes bound to...
  6. pl626

    subform requery macro doesn't work in main form

    I've tried referencing the subform control in the mainform using 'Forms!<Main Form>!<Sub-Form Name>.Form!<Combo Box name>.Requery' with events:After Update, On Lost Focus, On Open, etc. No luck. The main form does not pass any data to the 3 subform controls. It only collects information for a...
  7. pl626

    subform requery macro doesn't work in main form

    I have and Access 2007 app with a subform that has 3 controls that pass filter criteria to from one control to the next. When only the subform is open, it works fine. However, when I run the subform from my main form, I get a prompt to enter the value from the first control. How do I get the...

Part and Inventory Search

Back
Top