Paul is right. Or post the SQL of the form's Record Source and tell us what you
want to be able to lookup and move to, and we can give you the code.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Paul
Sent: Wednesday, October 05, 2011 5:40 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Control Wizards not working in Access 2007
You can always use the wizard on a test form based on a single table, then copy
the code to your actual form and adjust object names as appropriate.
Paul
--- In MS_Access_Professionals@yahoogroups.com, "David Tolson" <drtolson@...>
wrote:
>
> Thank you Paul. The form is based on three tables, so that must be the
> problem. I'll have to move in another direction.
>
>
>
> r/David
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Paul
> Sent: Tuesday, October 04, 2011 7:53 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Control Wizards not working in Access 2007
>
>
>
>
>
> For that option to show up, the form must be bound to a table. I don't think
> it will show if the form is bound to SQL or a query, and it definitely won't
> show if the form is unbound.
>
> Paul
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "djsdaddy531"
> <drtolson@> wrote:
> >
> > Great Day, I am trying to create a combo box that will look for a record.
> I clicked "Use Control Wizards" in the Controls section of the Design tab;
> however, after clicking onto the Combo Box control, I only get two options
> and not the third one that says "find a record in my form based on the value
> I selected in my combo box." I have other forms where that option shows up,
> but not on this form.
> >
> > Thanks in advance for your assistance.
> >
> > r/David
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar