RE: [MS_AccessPros] Search data of subform from Main Form

 

Kumar-

You didn't include my reply, so I have no clue what you're talking about.

Ah, when I go on the web, I see that my reply got totally hosed. 3D is part of some bad HTML on the site. Trying again in plain text:

If Not IsNull(Me.cboSearchSEnum) Then
strWhere = strWhere & "(SESNum = " & Me.[cboSearchSEnum] & ") AND "
End If

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri@yahoo.com
Sent: Tuesday, December 03, 2013 10:52 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: RE: RE: RE: RE: RE: [MS_AccessPros] Search data of subform from Main Form

John,
The coding gives syntex error in the strWhere = section.
What is the purpose of 3D?

Regards,
Kumar


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote:

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (14)

Recent Activity:

• New Members 2

Visit Your Group

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

.

__,_._,___