If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Limited sub records to 5 records only
Hi all,
I have a form with a subform in it. I want the records in the subform that relating to the main form is limited to 5 records only.Usually when we working with a continuos subform,when we are editing the first record the second blank new records will show up.And I want when the user is working at the fifth record, the sixth blank new record will not showing up. Is it possible?How to do it? |
#2
|
|||
|
|||
Limited sub records to 5 records only
New Project,
I didn't test, but I think this should work, on the After Update event of the subform: Me.AllowAdditions = (Me.RecordsetClone.RecordCount 5) You may need something equivalent on the main form's Current event too. -- Steve Schapel, Microsoft Access MVP New_Project wrote: Hi all, I have a form with a subform in it. I want the records in the subform that relating to the main form is limited to 5 records only.Usually when we working with a continuos subform,when we are editing the first record the second blank new records will show up.And I want when the user is working at the fifth record, the sixth blank new record will not showing up. Is it possible?How to do it? |
Thread Tools | |
Display Modes | |
|
|