Limit Subform to One addition - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Limit Subform to One addition

Marc Spragg

4 years ago

Hi There,
I have a situation where i want to limit a subform to only allow one entry. I have a situation where i need to allow many invoices details to One invoice and many invoices to One PO but for this particular vendor invoicing i want only to allow one invoice detail to one invoice. As this data is in the same tables i cannot change the relationship to one to one. I am trying to do it at form level as i have set the form and subform specifically for this vendor. I have tried the code in the subform Current event (attached) but cannot get it to work. Can anyone help?
Many thanks
Marc

	Marc Spragg OP @Reply 4 years ago

	Marc Spragg OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
You could do something similar to my screenshot below. I used the Contact Subform on my Customer Form as an example.

	Kevin Robertson @Reply 4 years ago

	Marc Spragg OP @Reply 4 years ago
Thanks Kevin, im getting the same error as before "Compile Error: Method or Data member not found" I also tried putting the SubF name before the .Recordset and .allowadditions but still the same error.

	Marc Spragg OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
Marc, You are referencing a Subform so you need to add `.Form` after the Subform name. `With WorldCouriorBlanketPOInvoiceSubF.Form`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View