Retrieving Records and Submitting New Records

[c9ola]

I have a 'Retrieve Records' button that pulls in the records that exists for
a user. It works well, the user can see the records that are in the database
for them and make updates if necessary. I received help from an earlier post
on how to show those records in descending order so that the newest record is
at the top (thank you Clay Fox!). My question now is, the 'Insert New Item'
blank record is way at the bottom, if the user selects the 'Retrieve Records'
button. (This is a repeating section form.) Is there a way I can move this
to the top so it's the first thing a user sees if they decide to click the
'Retrieve Records' button? Thank you.

 

[Ben Walters]

Hey KRH,

If I understand you correctly you want to move the "Insert New Item" link to
the top of the repeating section. Unfortunatly this is not possible as it is
expected that a repeating section will expand down or across. A way around
this however would be to add a standard button with some code behind it to
insert the new record into the repeating section.

If you need help with this let me know and I'll shoot some code through

Cheers,
Ben Walters

 

[c9ola]

I had a feeling it could not be done, but also thought that there may be a
work around . . . which sounds like you have. Yes, please shoot through some
code when you have time. Thanks so much, Ben!

 

[Clay Fox]

Here is one trick.
Insert another repeating table above yours bound to the same repeating group.
It will have the insert link. Then set conditional formatting to hide the
rows. You can then also remove the header. The UI is somewhat rigid but it
works. Since both of these sections are bound to the same group the insert
will go where you want it. You can turn off the insert on your main section
if you want?
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

I had a feeling it could not be done, but also thought that there may be a
work around . . . which sounds like you have. Yes, please shoot through some
code when you have time. Thanks so much, Ben!

 

[c9ola]

Hmmmmm. I haven't had a chance to try this yet, but sounds doable. Thanks
so much and I will post once I try it.

 

[c9ola]

I'm taking a look at it now and have some questions.
1. What I have is a repeating section. When you say to insert another
repeating table, do you mean another repeating section?
2. How do I bind it to the current repeating section that I have?
3. How do I turn off the insert on my main section?

Sorry so many questions, but want to be clear that I understand. Thank you!