Prev: "Your network access was interrupted."
Next: excel 2000
From: David Sigetich David on 5 Apr 2010 17:17
Thanks, Tom. This worked great.

And the reason this isn't in MS Access Help is what, exactly? Why does this
have to be so difficult? Surely using a combo box as a means of finding a
record isn't some weird obscure desire.

Oh, well -- you fixed it. Kudos, man!

"Tom Wickerath" wrote:

> Hi Kevin,
>
> The form that you are having trouble with is based on a SQL statement,
> instead of a saved query. Open the form in design view. Click on View >
> Properties, if required, to display the properties dialog. Click on the small
> black square in the upper left corner to select the form. You should see the
> word "Form" in the blue title bar of the properties dialog. Click on the Data
> tab. The first entry is for Recordsource. I'm fairly certain that your
> recordsource starts with a SELECT statement, instead of being a saved table
> or query. Click on the build button to open the query builder. Save the
> result as a new query, by clicking of File > Save. Then close the query
> builder. You should now have the third option available.
>
> Combo box to find a record
> http://www.access.qbuilt.com/html/find_a_record.html
>
>
> Tom Wickerath, Microsoft Access MVP
>
> http://www.access.qbuilt.com/html/expert_contributors.html
> http://www.access.qbuilt.com/html/search.html
> __________________________________________
>
>
> "Kevin" wrote:
>
> > I want to add a combo box to a prieviously built form, to allow the user to
> > choose a customer record, rather than having to scroll down through the
> > records to find it. When I go to add the combo box, though, the radio button
> > for "Find a record on my form based..." does not appear. When I create a
> > combo box on a new form, in the same DB, based on the same query, it is
> > available. Any ideas about why this could be, and how to make this option
> > available in this form?
> >
> > thanks
 | 
Pages: 1
Prev: "Your network access was interrupted."
Next: excel 2000