[MS_AccessPros] Re: Cannot Solve a Simple OpenForm Problem

 

Duane:

Thanks. That works very nicely. But why didn't my approach work? I had previously tried a string similar to yours in the DoCmd OpenForm line. The examples in Access (and in the Microsoft developer forum) never mention having to declare a string outside that cmd. Was that one of those everyone knows that things?
Jack

--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> Change your code to:
> Dim strWhere as String
> strWhere = "[AircraftID] = '" & Me.AircraftID & "'"
> DoCmd.OpenForm "frmTenantInput", acNormal, , strWhere, , acDialog
>
> Duane Hookom
> MS Access MVP
>
> --- In MS_Access_Professionals@yahoogroups.com, "robsonjack" <robsonjack@> wrote:
> >
> > I'm sure I'm missing something simple but any help would be greatly appreciated. I cannot get the "where" portion of OpenForm ... to work. I've uploaded a file called Troubleshooting11 to the downloads section. You have no idea how long I've messed with this.
> >
> > Thanks for any help.
> >
> > Jack
> >
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 7
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___