Re: [libreoffice-users] Re: macro - find record based on text entry

Hi Alex,


> Le 30/04/2015 22:09, Joel Madero a écrit :
>
> Hi Joel,
>
> > I have a form with a simple text document, what I'm hoping to do is take
> Is the text in question free-standing, as in, in a paragraph outside of
> a form control, or is it the value of a form control ?
Currently I just have a form with a text box with a button next to it
that says "add." I want the add button to run the macro that takes the
value from the text box, first searches a table and if found, opens
another form to that record, else, I want it to insert a new value into
the corresponding table, and then of course open a different form so I
can insert all of the required fields.
> > the text to open another form and for it to automatically be at the
> > record that matches the text. If the value does not exist, I want the
> > entry to be added to the related table.
> So, if I've understood correctly, you want to use that text string as an
> input value for a filter or a query that will pull up the corresponding
> record in the second form ?
Spot on :) Sorry for not being clear in the last go.

If needed I can give more details, just ask and I will do so :)


Best,
Joel

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted