Using Control Box to Find Records

[bhujanga]

I have been going along using the Control Box wizard to put control boxes on my forms that will look up a specified record. It seems to me like when I have placed the control on my form the first question it asks is something like "What do you want this control box to do?" and one of the options is "Find a record based on...". Now it is no longer asking me that question, and I'm not having much luck setting up the code myself.
What has happened to change this behavior?

Thanks.

 

[PHV]

The Form should be bound (ie have a RecordSource) for the the 3rd option of the combo wizard to be active.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bhujanga]

Your comment got me on the right track. Here's what I found.

My form was in fact already tied to a record source, but I had invoked the query builder on it from the 'Record Source' line to filter it down to only the records that met a certain category designation.
Interestingly, once you do this, the option for finding a record goes away from the control box wizard, but if you put the control box in there before you invoke the query builder on the data source, it still continues to function normally after you invoke the query builder.
So, just for grins I also tried building the query outside of the form and using it for the data source. When you do this, the combo box wizard is perfectly happy to allow the 'Find a Record.." option. This seems more straight forward than having to place the control and then alter the data source after the fact, but it of course creates a permanent query in your object list, which I personally like to keep to a minimum. So I guess it's 6 of one and half a dozen of the other.

Thanks for your help.