Limit Datasheet Subform to just one record.

[TimSG]

I apologize if this is in the wrong Forum - I wasn't sure if this should be in the Form or the programming forum. I have a Form with a subform that is a datasheet that ties to a table. What I need to do is limit only one record for that particular form/subform combination. The main form gives a Quote number and the date of the quote, while the subform contains other fields tied to other tables. They are tied to the other tables where they can select the data they need (Like product, or salesman).

So, I need the subform to only list one record. I need it to allow to add a record when there are no records and only allow editing when a record exists. My forms are titled Quote and Quote Subform - how original.

I've checked on this forum and didn't see anything that was similar (but maybe I am blind) and also checked the interweb and only found one example that didn't seem to work for me.



Can someone point me in the right direction?

[ranman256]

set the query of the subform to show only 1 record by:
use top 1,
or
use a key on the subform so only that 1 record shows,

you can set the subform property to ALLOW NEW RECORDS, if rec.count = 0
then ALLOW NEW RECORDS = false if rec.count>0