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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RichMax

  1. RichMax

    Need to add a row in a SubForm

    I have mostly been sucessful in setting up my forms to add new and update existing rows. I took your advice Remou, and defined the table name in the RowSource property of the Combo Box. I still cannot add a row with an empty field where a foreign key should be (I am using a view comprising...
  2. RichMax

    Need to add a row in a SubForm

    Thanks Remou, I'll give it a try.
  3. RichMax

    Need to add a row in a SubForm

    I am joining Source Group because the query is used to add entries to Reports and one of the components is Source Group which needs to be either Null or a valid entry in the Source Group table. Richard
  4. RichMax

    Need to add a row in a SubForm

    Here's a little more info on my query where I could not add a new row. I removed all JOINs from the query and then I could add rows to it. The query is as shown below: SELECT Reports.[Report Code], Reports.[Report Name], Reports.Description, Reports.SAE, Reports.[Used by Max], Reports.[Used...
  5. RichMax

    Need to add a row in a SubForm

    Thanks for your help so far Remou. I cannot add a record to the either the form or the subform query. The subform query is as follows: SELECT [Report Recipients].[Report Code], [Communication Medium].[Communication Medium], [Report Recipients].Encrypted, [Report Recipients].Recipient...
  6. RichMax

    Need to add a row in a SubForm

    I removed the subforms from my form so that only the master table and 1 joined table were defined. The query is as follows: SELECT Reports.[Report Code], Reports.[Report Name], Reports.Description, Reports.SAE, [Source Group].[Source Group], Reports.[Used by Max], Reports.[Used by Max - More...
  7. RichMax

    Need to add a row in a SubForm

    I am using the Access 2003 forms creation wizard to create a Data Entry (DE) form which has 2 subforms that show related data in a grid manner. In both the main DE form and the grid subforms, I have several elements that are combo boxes. The composite form displays existing data correctly and...
See more

Part and Inventory Search

Back
Top