sql/basic question

cassio · Newbie Joined: 29 Apr 2011 Posts: 3

I have two fields in my form (combo boxes) and when I select them and press a button I want to jump to the form entry where those fields exist. How would I do this? I have basetools downloaded already, and I think what I want is a macro.

--Sam

sainttomn · Posted: Fri Apr 29, 2011 2:03 pm Post subject:

Hi Sam, welcome to the forum.

I think we may need a little more information about your form to be able to assist.
_________________
"I'm a loner, Dottie. A rebel."
[Windows 7] [OO.o 3.3] [HSQL 1.8]

The Lazer Cat

Villeroy · Posted: Fri Apr 29, 2011 2:24 pm Post subject:

Both macros and combo boxes are the least useful things in Base.
In form design mode set property "Filter Proposal" for your text fields.
While working with the form, turn on the form filter mode. Now your text fields turn into list boxes where you select your filter criteria.

All about macro free filters: http://dl.dropbox.com/u/10552709/FilterExamples.zip
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

cassio · Newbie Joined: 29 Apr 2011 Posts: 3

That's very helpful. I will do that. What other information do you need from me in order to assist? I basically want to be able to jump to a specific record when a button is pushed as corresponding to the selected filter/form data.

Villeroy · Posted: Fri Apr 29, 2011 11:42 pm Post subject:

There is a search tool (binocular icon) which jumps to records according to search criteria.
You can not jump to specific records if your records unspecific in respect to the used criteria fields. If they are specific, a filter takes you to any specific record.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org