Inputing data to 3 tables from one input form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Box 666 (box666_at_mystical.demon.co.uk)
Date: 09/04/04

  • Next message: Douglas J. Steele: "Re: multiple entries for a search field?" 
    Date: Sat, 04 Sep 2004 18:16:08 GMT

    I am trying to update 3 tables from one input form, however the help file
    tells me I cannot do this. I have tried to get round it by joining 2 querys
    together, which also does not let me enter data.

    I have tried using a sub form, which does work, but I really wanted the data
    on 3 tab pages. Is it possible to place a sub form onto a tab page, again I
    cannot get it to go.

    Can somebody please advise me, what is the best solution to the problem of
    inputing data to 3 tables from one input form.

    Bob

  • Next message: Douglas J. Steele: "Re: multiple entries for a search field?"

    Relevant Pages

    • Re: Inputing data to 3 tables from one input form
      ... Use subforms. ... you can place a subform on a tab control page. ... Is it possible to place a sub form onto a tab page, ... > inputing data to 3 tables from one input form. ...
      (microsoft.public.access.gettingstarted)
    • using tab control
      ... I am a newbie to tab controls on forms... ... FROM WO INNER JOIN Asset ON WO.AssetNo = Asset.AssetNo ... Using a specific date range from my date input form I am returning 33 records. ...
      (microsoft.public.access.formscoding)
    • How do I use the value from a subfrom field as criteria in a query
      ... I have a membership database and within the main input form is a sub form for ... control to the form that calls a query which checks to see if the address has ...
      (microsoft.public.access.forms)
    • Re: Replace a character in a string variable
      ... I have a variable which is created from an input form. ... After concatenating the input I want, I end up with a variable named ... First 2 parameters the wrong way round, ... :) no prob! ...
      (comp.lang.php)
    • Re: Replace a character in a string variable
      ... I have a variable which is created from an input form. ... After concatenating the input I want, I end up with a variable named ... I want to take this string and replace all the commas with this: ... First 2 parameters the wrong way round, ...
      (comp.lang.php)