Button Actions2

[Melissa101]

Also,
How do I use a query button to do a search?

Can I have a "Next" and "Previous" button to again search through the
records already in the database?

Is there a way to have a button to just close the form?

Sorry for so many questions but as I research the button actions
themselves...there's not much there

 

[Adam Harding]

Use queryfields not Datafields to search on and then use a query button

You can use a button to close the fiorm by changing it to use rules and
custom code and using the rules to close the form.

I think i have covered the next and previous in your previous post.

Cheers Adam

 

[Melissa101]

Sorry Adam ...I'm trying to do what you said but I think I'm missing some
steps or something. Do you think you could try explaining it with a little
more detail?
So I go to the button and chose "Rules and Custom Code" for button action?
is that where I want to be? and how do I set each record (you mean?) with a
unique Id? so sorry....little confused

 

[Adam Harding]

Melissa101 sorry for not getting back to you earlier been wrapped up in my
own issues (see a little later on the board)

Unique ID is an ID field or similar from a Database that autonumbers a
record with sequential numbers. You will have to cheque you have a field
like that in your database then you will have to go into data connects modify
your main data connection and check the ID field into the form. This can
then be used to reference each line of detail.

You are in the right place for 'Button Action' as you put it. Now for your
next button your rule should have no conditions and say

Set a field's value: Queryfield Unique ID: *Value

*Value is the value given by taking the current Datafield Unique ID value
say 7 and then adding a "+" sign then adding the number 1 after the "+" sign.

Then your next action would be to query using a data connection and you then
select the main datasource. (if the person using the form has used other
queryfields to get to the current record they need to be cleared before using
the query)

This will then give you the data from the next record, repeat the same with
the previous button and "- 1_ instead of the "+ 1"

I hope this helps

Cheers Adam