Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

SQL UPDATE table ...

Discussion in 'Information Technology' started by fth, Jul 28, 2006.

  1. fth

    Expand Collapse


    I've a problem to solve this:

    FMainFmD is my main form with my contact list
    FSubMontDemDetail (Details) showing records link to my contact
    (relation 1-n) data provided by table "eventDetail"
    In FSubMontDemDetail (Form Header), I've some unbounded fields (DefTotNbr,
    DefmidiMange, ... with default value I want in all records visible in
    table EventDetail)

    then I make following code:

    Private Sub BtAttrib_Click()
    DoCmd.RunSQL ("UPDATE EventDetail " & _
    "SET " & _
    "EventDetail.TotalNbr =
    [Forms]![FMainFmD]![FSubMontDemDetail].[Form]![DefTotNbr]," & _
    "EventDetail.Rmidi =
    [Forms]![FMainFmD]![FSubMontDemDetail].[Form]![DefmidiMange]" & _
    "WHERE (((FSubMontDemDetail.IdBenev)= me![ID]));")

    My button is in FMainFmD form.

    Someone to help me on this?
    many thanks by advance

  2. Loading...

    Similar Threads Forum Date
    Microsoft Brings 64-Bit Perks in SQL Server 2000 Service Pack (Ziff Davis) Interfaith Dialogues May 7, 2005
    update Blogs Oct 16, 2015
    Update Wikipedia enteries on Sikh Socio-Political Topics Breaking News Jul 19, 2015
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014
    Opinion "Sikh monument" irks Kenyan Kisumu preachers (UPDATED) Breaking News Feb 8, 2014

Share This Page