Record selector

[Vulcan1500]

I made a seach form with some controls to filter the data in the continuous form. Most of the times after filtering I end up with 10-20 records. Now I'm trying to access a record with the3 record selector to view aal the fields of this record in a other form. Here I'm stuck and cannot get access. Maybe one of you can give me directions. Thanks in advance.

 

[ajetrumpet]

I made a seach form with some controls to filter the data in the continuous form. Now I'm trying to access a record with the3 record selector to view aal the fields of this record in a other form.

Elaborate. Not understanding this...

 

[Vulcan1500]

I will try to explain my problem more specific. At this moment I have a form based on a continuous form and a query that gives only part of the data of a market survey data table. In this form I can seach quickly for records using 6 parameters in controls. The result is that mostly 10-20 records are left after filtering. Now I want to view all the data of the market survey by pointing with the record selector to a specific record of the result. My current problem is that I do not know/understand how to get access to a record via the record selector. I hope this will help you to understand my problem and hope you can help me with this.

 

[stopher]

If I understand you correctly you want to select a particular record line and then open up a new form that shows the full detail associated with that line?

You can do this by adding a button to your form. Use the button wizard and select Form Operations=>Open Form. There will be a point where you can select "Open the form and find specific data to display" and thereafter you can define the key fields which define the correct record to display.

Chris

 

[Vulcan1500]

Record Selector

Indeed Chris that is my aim. Is it possible with your advice when I point with the record selector to the 11th record then the form will show this record. I mean in a way the form needs to know which recor must be opened. That is my problem. I do not know how to define the data where the selector is pointing at.

 

[stopher]

Indeed Chris that is my aim. Is it possible with your advice when I point with the record selector to the 11th record then the form will show this record. I mean in a way the form needs to know which recor must be opened. That is my problem. I do not know how to define the data where the selector is pointing at.

If you run the wizard as I describe then it will know to use the current record as the key to the data for your next form. The wizard writes all the code for you so you don't have to worry about telling it anything more than then key field. Try it.

 

[Vulcan1500]

Record Selector

Thank you very much Chris. It works perfect. Only finetuning the final form and that's it. Great. Was suffering during the weekend to find a solution. Thanks again. Pieter.