Combox on form that has already been filtered

[Katemart]

Hi

I have a form which has a parameter query offering one of three options (A, B or C) or ignore in order to return All the records.

On the form itself there is a dropdown combobox which allows users to jump straight to their required record. This filters records by referring to the same item that is used in the parameter query so that users who chose option B will only be a presented with a jump-list for option B records.

That's great for my users, but I am the one who uses All the records and I want an (unfiltered) jump-list in the combobox for me!

At present, the list in the combobox shows the filtered list according to whichever option is first in the recordset when the form is opened. Can anybody tell me whether it is possible to get the combobox to return all the records when the parameter query is cancelled, please?

Thanks in advance!

Kate

 

[llkhoutx]

Filter the records using the form FilterOn and Filter properties to indicate what data is the be displayed. Consider using the user name or a password in setting the filter for your various users.

 

[JHB]

...
At present, the list in the combobox shows the filtered list according to whichever option is first in the recordset when the form is opened.

Can't you check if there are more as one option in the recordset?

 

[llkhoutx]

Filter the form based on the combo box value.

 

[Katemart]

Hi, thank you for your responses.

llkhoutx, the filter is based on the value of the combobox on the previous form. It works perfectly for the users who only require access to their records. But it does not take the "All" option to show an unfiltered list for me. Instead it just shows the filtered list matching the A, B or C of whichever is first record when the form loads.

I'm not a coder so if anyone can point me in the direction of a VBA example for checking which recordset has been loaded I'd be very grateful!

Cheers again

Kate

 

[arnelgp]

is it a FE/BE database?

create an FE without restriction for your own use only with all parameters removed from your query.

 

[Katemart]

Hi, arnelgp

Yes, it is an fe/be database. That is a possible solution, thank you. However, knowing how forgetful I am it won't take long for me to forget and overwrite the shared front-end. I could also set up a different button in the main menu, I suppose, but I would really like to code this is in, if it were at all possible. I will have a bash at looking at the recordset for more than one option tonight - I guess DCOUNT might work?

Many thanks

Kate