Hi

I'm wanting to invoke the edit form from an add record button click so where on click a new record is created in the table and the edit form opens so additional details can be enetered. I have read Ryan's article titled "How to generically invoke the edit form for a SalesLogix datagrid" but can'r get my code to behave in the same way.

My code is as follows:

application.BasicFunctions.ShowViewForRecord(COMMISSIONS As String, Personal:Commission Manual Add As String, strNewID As String) As ModalResult

COMMISSIONS - is the table where the new row is being created.

Personal:Personal:Commission Manual Add - is the form that is being called to edit

strNewID - is the new record id

Can I just insert this line of code at the end of the create new record code? 

It is falling over on syntax checking with an error "Expected ')' " which is after the COMMISSIONS part of the code.

Can anyone advise as to why this is falling over?

Am I using this function in the right way?

Dave

I'd say no.

If you already have the ID off the grid then you simply do:

Application.BasicFunctions.ShowViewForRecord "TABLENAME","ViewName",YourID

e.g

application.BasicFunctions.ShowViewForRecord "COMMISSION", "Personal:Commission Manual Add", strNewID

If you need to know the result then use:

x = application.BasicFunctions.ShowViewForRecord("COMMISSION", "Personal:Commission Manual Add", strNewID)

and x will be the result (0/1 etc).

Thanks  Mike that worked a treat.