Selecting only One Record in a Continous Form

[McObraz]

Hello all,

I wish to get some assistance on having only one record display in a continuous form, after an "On Click" event. The database in which this question lies is attached.

On opening, the user first interacts with Table 1 (Continuous Form), then by clicking on ID on the details for that particular record appear.

What I would like to do is: When the user clicks on ID, only that record whose ID has been clicked on displays first on the continuous form, and then the PERSONAL form opens. To clarify further, my wish is that the sequence of events is:

1. User Opens Table 1 Form
2. User Clicks on ID (for example, let's take 2)
3. Only Record with ID 2 remains on the Continuous form.
4. Then details for record 2 display on the Personal Form that opens next.

The problem I currently have is with step number 3 above, and I do not have any clue about what to do, so any help will be greatly appreciated.



Thanks.

Maurice

 

[namliam]

Have you thought about doing something like:
Me.Filter = "ID = " & ClickedID
me.filterapply (forget the exact name)

 

[David R]

Me.Filter = True

 

[McObraz]

Namliam and David R,

Thank you very much for your useful replies. However, I seem to be having a problem implementing your suggestions. The filtering option would only apply to the form, and not the query which contains the data behind the form. I wish to filter the data, yes, but based on the query behind the form.

This is because, after filtering, there are other items which I would wish to print (for a single record), whose data is primarily from the query behind the form.

I hope this clarifies things further.

Again, thank you very much for your assistance. Greatly appreciated. \

Thanks.
Maurice

 

[McObraz]

Hello.

Just an idea: Could there be a way of, say, at an "On Click" event, the ID in the active box is posited to the query, then the query runs, in turn displaying only one record in the continuous form? I would however, need to have another event that would run so as to clear the ID, after I am done with one particular record.

Just a thought.

Thanks.
Maurice

 

[Mihail]

First of all why you need to do this on the underlying query ? For the user is equal. He see only what you show: the form.

The answer to your question should be NO while what you wish to try sound as a cycle.

 

[namliam]

You can if you want adjust the feeding query as well, if you search for QueryDefs in the help you should be able to find a way to rework the sql to only retrieve the one record.

Not sure why the filter wouldnt be enough, the "active" record is where you could fetch your information from for "Printing" unless you want to recycle the query to the form to some kind of report as well?

 

[McObraz]

First of all why you need to do this on the underlying query ? For the user is equal. He see only what you show: the form.

The answer to your question should be NO while what you wish to try sound as a cycle.

Mihail,

Thanks for your response.

I wish to do this to the underlying query because from the active record, I would wish to print some other reports too, based on data retrieved from the query.

The user's interaction with the data on the continuous form should just be so that only one record is viewed, but the real issue lies in having it so that at the point of printing of other reports, the data is only retrieved from the query (based on an ID that was posited there during an on-click event during record selection)

I hope I haven't muddied the waters further. Again, thanks for your help.

Thanks.
Maurice.

 

[McObraz]

You can if you want adjust the feeding query as well, if you search for QueryDefs in the help you should be able to find a way to rework the sql to only retrieve the one record.

Not sure why the filter wouldnt be enough, the "active" record is where you could fetch your information from for "Printing" unless you want to recycle the query to the form to some kind of report as well?

Namliam,

Thank you very much for your continued response.

Let me work on your suggestion about re-working the query (though I have tried it before, but I may have missed something) then will let you know.

Yes, The reason I wish for the "filtering" to be based on the ID from the query is because from one record, there would be about four other reports have to be generated.

Again, thank you very much for your help.

Thanks.
Maurice.

 

[Mihail]

I wish to do this to the underlying query because from the active record, I would wish to print some other reports too....

DoCmd.OpenReport , , , WhereClause
Manage that the WhereClause to filter the report based on a value from your current record.

 

[namliam]

Like Mihail said, what is represented on the form in no way need to be linked to any report.... You can pass the information to the report when and where required.