Recent content by smithn293

  1. S

    Insert record into other table from form

    Cool, thanks for the help!
  2. S

    Insert record into other table from form

    So, for example #1, I just need to learn VBA I guess (I'm new to it). But the second example requires the use of fields created on a form that don't link to a table. Is that possible?
  3. S

    Insert record into other table from form

    Thank you both for your prompt replies. Let me take a step back to explain the concept I am trying to tackle. I am a software consultant for a specific software (not medical- this is different effort). In my software, we have a db schema that uses tables to link data together from different...
  4. S

    Insert record into other table from form

    Access 2007 In order to better design the data structure/table design, I need the ability to add a new record to a table based on data from a form as well as a value that is not in the form's table. For example: I am entering patient information (ID, name, birthdate, address, etc.). This...
Top Bottom