share functionality of ctrl rep. section between query/new record?

[GSS]

Hi,

Thanks to some previous help on the forum I have managed to get a control
repeating section working with navigation buttons to go through records
returned from a query in a linear fashion one by one from SQL connection.

Now - I am trying to use the same control repeating section to allow a new
record to be submitted using a new record button.

The problem is that when I click the new record button it wipes the info in
the control repeating section and does not show a blank form for the user to
complete and submit.

Any ideas please?

Regards,

Gavin

 

[Shiva]

Hello,

Did you changed the Action of that button from ‘Run Query’ to ‘New Record’?
Then you will get the blank section in that form. If you want you can add
three buttons with different actions like ‘Run Query’, ‘New Record’ and
‘Submit’.
Are you getting any error message?

 

[GSS]

Hi,

I have a 'run query' 'new record' and 'submit' button and they are set to
the appropriate actions. Setting the action of the button to 'New Record'
does not generate a new section. I have a repeating control section that
currently will show query results but I want it to also show a blank form for
entering a new record, any ideas?

Gavin.