I know that @CreateNewRecord() can be used to add a new record to the current form. But, is there a way to add a new subrecord to a table view subform, from within the parent form?

I have a command button that launches a picklist that is used to fill an element in the lineitem row that last had focus before clicking on the button in the parent form. This works very well as is, but one drawback is that I need to first go to the subform and "arrow down" or press F10 to make a new line at the bottom of the lineitem rows. Then I click on the button in the parent form to bring up the picklist of items that will autofill the new subrecord.

I would like to automatically have the programming add a new subrecord each time I make a selection from the picklist. This would streamline the process tremendously. (I already used to launch the picklist from within the subform programming, but that caused other issues.)

If there is no way to do this now, I would like to suggest that a future release might have the ability to use something like:
@CreateNewRecord("MySubform") or @FormCreateNewRecord("MySubform").

Thank you so much, Mark. I was surprised when I didn't find a function for that purpose, because I figured that you would have already provided a way to do that. But, of course, you did.

I can't believe that I overlooked it, since it appears on the same page in the programming guide as @CreateNewRecord.

I guess I was fixated on the idea that the function would have "Create" somewhere in its name. I kept running searches for the word "Create", but the description for that function just states, "Adds a new record...".

Anyway, thanks again for pointing it out.

Quote:

You meant the verb "Create", didn't you?