[MS_AccessPros] Re: Cannot Solve a Simple OpenForm Problem

 

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 (2)

Recent Activity:

• New Members 7
• New Files 2

Visit Your Group

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

.

__,_._,___