Filter?

[deejay_totoro]

Hello all,

I have a question concerning filtering. My objective - I have have seen done in other databases, but I cannot work out how to do it myself. This is what I would like to do:

From a list box showing all the records in a database, the user chooses a record, for example record number 1, with an ID of 1.

What I would like to do is when the user clicks on the "Open record" button, a new form opens up showing just that selected record.

My guess is that this is something to do with filters? But I am not quite sure!

Any help would be much appreciated!

Many thanks,

dj_T.

 

[llkhoutx]

dim varitem as variant
dim Index as 'type of your index"
with me!Yourlistbox
for each varitem in .itemsselected
Index = .column(ij,varitem) 'ij is the field number (o to i) of the unique record index whether it's visible or not
next
end with


Then use that "Index" as a filter for you form whether using the Filter and the FilterOn properties or modifying the form recordsource. In either event then requery the form.

 

[beef]

Have a look at this link Link


Cheers!!!!

Lou

 

[Rich]

Just use the Where clause of the OpenForm method

 

[deejay_totoro]

Where?

Thanks for the replies.

Rich - I am not sure how to do that? If possible, could you explain that to me

Thank you!

dj_T