I have a 9 table hierarchy database, I am wanting to create a search
form with a Combo Box to search for a particular record (as put in the
Text Box) and then display the requested record in the form.
I created the search form with a Text Box with a command button. On
the properties menu of the command button, under the Event Tab, I
added the following code to the On Click event:
Private Sub Command19_Click()
DoCMD.OpenForm fmSearch, acNORMAL
WHERECONDITION=”[taPROPERTY.CLT]=” & me.TextBox1
End Sub
taPROPERTY is the ‘top’ table in the database and CLT is the primary
key which connects the remaining tables.
This does not work, I am sure my coding is not correct as I’m not that
confident in my ability to properly code this.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
