[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

How to make linked SUBFORM only allow entry for one record.

I need my subform to allow only one record to be entered.  When I turn the addrecord property to no, it doesn't allow me to add a record.  I would like to allow me to add one record but not a second.

Thank you.
1 Solution
There may be a better way but.......
What if you set the addrecord property to No, but add a record (null or "" in a given field) using code when the form loads.  To add the record you could use an ADO recordset or maybe Docmd.  The user then types over the empty field with their data.
You could then set the form up to look like it is a one to one.  May not be the tidiest but should work.
Open the form with it set to addrecord = yes In your afterupdate statement on the subform do a switch back to addrecord equals no

Unless you actually only want a single record for each main record.

If so better solutions, Is the sub form a separate table?

If so link the two table with a left join query from main table to sub table. Base the form on this. Make a 1:1 relationship. Done.

Subforms really are ore for a 1:M relationship.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now