How to Find a Record from a Drop-down List in a Data Access Page 1

Techniproshop · Apr 28, 2007

Hello all. I went to

http://support.microsoft.com/?kbid=247823

and found the info for my needs but it's not working. This is for Microsoft Access 2000 Standard Edition and I use Professional Edition. I don't know if that could be the problem. I have this code for my drop-down-list in my access page. The drop-down-list name is
"SPROJECT" and the field that I need to search is "PROJECT NO" wich is a text field. When I choose a project number from the drop-down-list, the page doesn't go to the project I choosed. Any idea?

<SCRIPT language=vbscript event=onafterupdate for=SPROJECT>

</SCRIPT>

fneily · Apr 29, 2007

Close. Usually questions about DAP's go in Microsoft: Access Other topics. In fact, if you search on DAP and "data access page" in that forum, you'll find alot of info on DAP'S.
Next. You placed code on the onafterupdate event. It should be on onchange. So
<SCRIPT language=vbscript event=onchange for=SPROJECT>

</SCRIPT>

Concepts. DAP's ARE NOT forms. They do not reside in Access. They are not coded like forms. They are web pages that live outside of Access with an extension of .htm. They are coded using JScript or VBScript. These are languages of the Internet Explorer Environment - not Access. So you'll not have "subforms", you can not reference data on another web page like you do in forms, etc.

Techniproshop · Apr 29, 2007

Hi. I changed the code to "onchange" but still doesn't work. Is that code compatible with Access 2000?

fneily · Apr 30, 2007

Ok. Let's go through the steps. First, I use Access 2000. Second, again, you ARE NOT programming in Access, no matter what version. You are programming in Internet Explorer. You need to have IE 5.0 or greater.
Do not "change" anything. Start all over.
Create a query to pick off all the [Project No]. Use this to create your combobox.
GoTo design view of your DAP (not form). Your combobox should be created in the Header Section. The ID of the combobox will be SPROJECT. Click on the combobox (not label). Right click the combobox and select Microsoft Script Editor. On the left under Client Objects and Events, double click the combobox name. Double click on "onchange". On the right, you'll see the
<SCRIPT language=vbscript event=onchange for=SPROJECT>
line. Type in your code there.

If you have any other problems, please describe exactly what you are doing.

Techniproshop · Apr 30, 2007

ok I have IE 6.0, Fine.
I did exactly what you said the first time and it didn't work so I created a brand new page and followed the steps. My combobox is listing the PROJECT NO. No prob there. The combobox is in the header section. Ok. The Id of this combobox is "SPROJECT". In the script editor, onchange, I wrote the code. I saved the page. When I open it, I got this message:

Problems with this Web page might prevent if from being displayed properly or functioning properly.

-------------------------------------
Details:

Line 68
Char 7
Error: Expected end of statement
Code 0
--------------------------------------
I didn't get that message the first time I created this page. If I close the page and re-open it, the error message doesn't show up anymore. weird...!

Below is all the code for the page:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML XMLNS

="urn:schemas-microsoft-com

ffice

ffice"
XMLNS:x="urn:schemas-microsoft-com

ffice:excel"
XMLNS:a="urn:schemas-microsoft-com

ffice:access"
XMLNS:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns

=
"urn:schemas-microsoft-com

ffice

ffice" xmlns:x =
"urn:schemas-microsoft-com

ffice:excel" xmlns:a =
"urn:schemas-microsoft-com

ffice:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>TEST</TITLE><LINK
href="./Page1_files/filelist.xml" type=text/xml rel=File-List>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<STYLE id=MSODAPDEFAULTS type=text/css rel="stylesheet">.mstheme-label {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
.msoboundhtml {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
HR {
COLOR: black
}
SELECT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
INPUT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BODY {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
MARQUEE {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
LEGEND {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
.msoHyperlinkDisplayText {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
.MsoShowDesignGrid {
BEHAVIOR: url(#DEFAULT#MsoShowDesignGrid)
}
</STYLE>

<OBJECT id=MSODSC codeBase=P:\Off2K\En\msowc.cab
classid=CLSID:0002E530-0000-0000-C000-000000000046><PARAM NAME="XMLData"
VALUE="<xml
xmlns:a="urn:schemas-microsoft-com

ffice:access">

<a

ataSourceControl>

<a:OWCVersion>9.0.0.6621</a:OWCVersion>

<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=M:\CIMIC\Database\DCO PROJECT\DATABASE\PRTPSM.mdb;Mode=Share Deny
None;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB

atabase
Password=&quot;&quot;</a:ConnectionString>

<a:MaxRecords>10000</a:MaxRecords>

<a:GridX>24</a:GridX>
 <a:GridY>24</a:GridY>

<a:ElementExtension>

<a:ElementID>TblProjectsNavigation</a:ElementID>

<a:ConsumesRecordset/>
 </a:ElementExtension>

<a:ElementExtension>
 <a:ElementID>PROJECT
NO</a:ElementID>
 <a:ControlSource>PROJECT
NO</a:ControlSource>

<a:ChildLabel>PROJECTNO_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>CATEGORY</a:ElementID>

<a:ControlSource>CATEGORY</a:ControlSource>

<a:ChildLabel>CATEGORY_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>VILLAGE</a:ElementID>

<a:ControlSource>VILLAGE</a:ControlSource>

<a:ChildLabel>VILLAGE_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>PROJECT TYPE</a:ElementID>

<a:ControlSource>PROJECT TYPE</a:ControlSource>

<a:ChildLabel>PROJECTTYPE_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>COSTS</a:ElementID>

<a:ControlSource>COSTS</a:ControlSource>

<a:ChildLabel>COSTS_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>CURRENCY</a:ElementID>

<a:ControlSource>CURRENCY</a:ControlSource>

<a:ChildLabel>CURRENCY_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>RATE</a:ElementID>

<a:ControlSource>RATE</a:ControlSource>

<a:ChildLabel>RATE_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>TITLE</a:ElementID>

<a:ControlSource>TITLE</a:ControlSource>

<a:ChildLabel>TITLE_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>DETAILS</a:ElementID>

<a:ControlSource>DETAILS</a:ControlSource>

<a:ChildLabel>DETAILS_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>OPI</a:ElementID>

<a:ControlSource>OPI</a:ControlSource>

<a:ChildLabel>OPI_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>PROGRAM REF</a:ElementID>
 <a:ControlSource>PROGRAM
REF</a:ControlSource>

<a:ChildLabel>PROGRAMREF_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>FUND SOURCE</a:ElementID>
 <a:ControlSource>FUND
SOURCE</a:ControlSource>

<a:ChildLabel>FUNDSOURCE_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>STATUS</a:ElementID>

<a:ControlSource>STATUS</a:ControlSource>

<a:ChildLabel>STATUS_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>DATE (MONTH/YEAR)</a:ElementID>

<a:ControlSource>DATE (MONTH/YEAR)</a:ControlSource>

<a:ChildLabel>DATE(MONTH/YEAR)_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>REMARKS</a:ElementID>

<a:ControlSource>REMARKS</a:ControlSource>

<a:ChildLabel>REMARKS_Label</a:ChildLabel>

</a:ElementExtension>
 <a:ElementExtension>

<a:ElementID>SPROJECT</a:ElementID>

<a:ListRowSource>QryProjectNo</a:ListRowSource>

<a:ListBoundField>PROJECT NO1</a:ListBoundField>

<a:ListDisplayField>PROJECT NO2</a:ListDisplayField>

<a:ChildLabel>DropdownList0_Label</a:ChildLabel>

</a:ElementExtension>
 <a:GroupLevel>

<a:RecordSource>TblProjects</a:RecordSource>

<a

efaultSort>[PROJECT NO] ASC</a

efaultSort>

<a:HeaderElementId>HeaderTblProjects</a:HeaderElementId>

<a:FooterElementId></a:FooterElementId>

<a:CaptionElementId></a:CaptionElementId>

<a:RecordNavigationElementId>NavigationSectionTblProjects</a:
RecordNavigationElementId>

<a

ataPageSize>1</a

ataPageSize>
 </a:GroupLevel>

<a

atamodel version="0816">
 <a:SchemaRowsource
id="TblProjects" type="dscTable">

<a:SchemaField id="NUM" datatype="3" size="0"
iskey="1"/>
 <a:SchemaField id="PROJECT NO"
datatype="202" size="50"/>
 <a:SchemaField
id="CATEGORY" datatype="3"
size="0"/>
 <a:SchemaField id="VILLAGE"
datatype="3" size="0"/>
 <a:SchemaField
id="PROJECT TYPE" datatype="202"
size="50"/>
 <a:SchemaField id="COSTS"
datatype="6" size="0"/>
 <a:SchemaField
id="CURRENCY" datatype="202"
size="4"/>
 <a:SchemaField id="RATE"
datatype="4" size="0"/>
 <a:SchemaField
id="TITLE" datatype="202"
size="250"/>
 <a:SchemaField id="DETAILS"
datatype="203" size="0"/>
 <a:SchemaField
id="OPI" datatype="3" size="0"/>

<a:SchemaField id="PROGRAM REF" datatype="3"
size="0"/>
 <a:SchemaField id="FUND SOURCE"
datatype="3" size="0"/>
 <a:SchemaField
id="STATUS" datatype="3" size="0"/>

<a:SchemaField id="DATE (MONTH/YEAR)" datatype="202"
size="50"/>
 <a:SchemaField id="REMARKS"
datatype="203" size="0"/>

</a:SchemaRowsource>
 <a:SchemaRowsource
id="QryProjectNo" type="dscView">

<a:SchemaField id="PROJECT NO" datatype="202"
size="50"/>
 </a:SchemaRowsource>

<a:RecordsetDef id="TblProjects">
 <a

ageField
id="NUM"/>
 <a

ageField id="PROJECT
NO"/>
 <a

ageField id="CATEGORY"/>

<a

ageField id="VILLAGE"/>
 <a

ageField
id="PROJECT TYPE"/>
 <a

ageField
id="COSTS"/>
 <a

ageField
id="CURRENCY"/>
 <a

ageField
id="RATE"/>
 <a

ageField
id="TITLE"/>
 <a

ageField
id="DETAILS"/>
 <a

ageField
id="OPI"/>
 <a

ageField id="PROGRAM
REF"/>
 <a

ageField id="FUND
SOURCE"/>
 <a

ageField id="STATUS"/>

<a

ageField id="DATE (MONTH/YEAR)"/>
 <a

ageField
id="REMARKS"/>
 </a:RecordsetDef>

<a:RecordsetDef id="QryProjectNo">
 <a

ageField
id="PROJECT NO1" source="PROJECT NO"/>

<a

ageField id="PROJECT NO2" source="PROJECT
NO"/>
 </a:RecordsetDef>

</a

atamodel>

</a

ataSourceControl>
</xml>'""></OBJECT>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR><!--[if gte mso
9]><xml>
<o

ocumentProperties>
<o:Author>bourassa.jpmg</o:Author>
<o:LastAuthor>bourassa.jpmg</o:LastAuthor>
<o:Revision>1</o:Revision>
<o:TotalTime>0</o:TotalTime>
<o:Created>2007-04-30T13:59:24Z</o:Created>
<o:LastSaved>2007-04-30T14:00:12Z</o:LastSaved>
<o:Company>DSB LCSF</o:Company>
<o:Version>9.8960</o:Version>
</o

ocumentProperties>
<o:OfficeDocumentSettings>
<o

ownloadComponents/>
<o:LocationOfComponents HRef="file

:\Off2K\En\msowc.cab"/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<SCRIPT language=vbscript event=onchange for=SPROJECT>

</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" bottomMargin=48 vLink=#800080 link=#800080
leftMargin=24 topMargin=24 rightMargin=24>
<CENTER>
<H1 id=HeadingText style="DISPLAY: none; FONT-WEIGHT: normal"
MSOTITLE="YES"> </H1></CENTER>
<P> </P>
<DIV class=MicrosoftAccessBanner id=HeaderTblProjectsBanner
style="BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP:
buttonhighlight 2px outset; DISPLAY: none; PADDING-LEFT: 1px; FONT-WEIGHT:
normal; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: buttonhighlight 2px
outset; WIDTH: 446px; BORDER-BOTTOM: buttonhighlight 2px outset;
FONT-FAMILY: Tahoma; HEIGHT: 0.2in; BACKGROUND-COLOR: buttonface">Header:
TblProjects</DIV>
<DIV class=MSOShowDesignGrid id=HeaderTblProjects
style="VISIBILITY: hidden; OVERFLOW: hidden; WIDTH: 446px; POSITION:
relative; HEIGHT: 440px; BACKGROUND-COLOR: transparent"><SPAN
class=MSTheme-Label id=PROJECTNO_Label title="PROJECT NO"
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 0.042in; HEIGHT: 0.177in">PROJECT
NO</SPAN><TEXTAREA id="PROJECT NO" title="PROJECT NO" style="LEFT: 1.125in;
OVERFLOW: hidden; WIDTH: 1.604in; POSITION: absolute; TOP: 0.042in; HEIGHT:
0.177in" tabIndex=1></TEXTAREA><SPAN
class=MSTheme-Label id=CATEGORY_Label title=CATEGORY
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 0.292in; HEIGHT: 0.177in">CATEGORY</SPAN><TEXTAREA
id=CATEGORY title=CATEGORY style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH:
0.729in; POSITION: absolute; TOP: 0.292in; HEIGHT: 0.177in"
tabIndex=2></TEXTAREA><SPAN
class=MSTheme-Label id=VILLAGE_Label title=VILLAGE
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 0.542in; HEIGHT: 0.177in">VILLAGE</SPAN><TEXTAREA
id=VILLAGE title=VILLAGE style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH:
0.729in; POSITION: absolute; TOP: 0.542in; HEIGHT: 0.177in"
tabIndex=3></TEXTAREA><SPAN
class=MSTheme-Label id=PROJECTTYPE_Label title="PROJECT TYPE"
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 0.792in; HEIGHT: 0.177in">PROJECT
TYPE</SPAN><TEXTAREA id="PROJECT TYPE" title="PROJECT TYPE" style="LEFT:
1.125in; OVERFLOW: hidden; WIDTH: 1.604in; POSITION: absolute; TOP:
0.792in; HEIGHT: 0.177in" tabIndex=4></TEXTAREA><SPAN
class=MSTheme-Label id=COSTS_Label title=COSTS
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 1.042in; HEIGHT: 0.177in">COSTS</SPAN><TEXTAREA
id=COSTS title=COSTS style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH:
1.604in; POSITION: absolute; TOP: 1.042in; HEIGHT: 0.177in"
tabIndex=5></TEXTAREA><SPAN
class=MSTheme-Label id=CURRENCY_Label title=CURRENCY
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 1.292in; HEIGHT: 0.177in">CURRENCY</SPAN><TEXTAREA
id=CURRENCY title=CURRENCY style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH:
0.583in; POSITION: absolute; TOP: 1.292in; HEIGHT: 0.177in"
tabIndex=6></TEXTAREA><SPAN
class=MSTheme-Label id=RATE_Label title=RATE
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 1.542in; HEIGHT: 0.177in">RATE</SPAN><TEXTAREA
id=RATE title=RATE style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 1.604in;
POSITION: absolute; TOP: 1.542in; HEIGHT: 0.177in"
tabIndex=7></TEXTAREA><SPAN
class=MSTheme-Label id=TITLE_Label title=TITLE
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 1.792in; HEIGHT: 0.177in">TITLE</SPAN><TEXTAREA
id=TITLE title=TITLE style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH:
3.167in; POSITION: absolute; TOP: 1.792in; HEIGHT: 0.177in"
tabIndex=8></TEXTAREA><SPAN
class=MSTheme-Label id=DETAILS_Label title=DETAILS
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 2.042in; HEIGHT: 0.177in">DETAILS</SPAN><TEXTAREA
id=DETAILS title=DETAILS style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH:
3.167in; POSITION: absolute; TOP: 2.042in; HEIGHT: 0.583in"
tabIndex=9></TEXTAREA><SPAN
class=MSTheme-Label id=OPI_Label title=OPI
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 2.708in; HEIGHT: 0.177in">OPI</SPAN><TEXTAREA
id=OPI title=OPI style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 0.729in;
POSITION: absolute; TOP: 2.708in; HEIGHT: 0.177in"
tabIndex=10></TEXTAREA><SPAN
class=MSTheme-Label id=PROGRAMREF_Label title="PROGRAM REF"
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 2.958in; HEIGHT: 0.177in">PROGRAM
REF</SPAN><TEXTAREA id="PROGRAM REF" title="PROGRAM REF" style="LEFT:
1.125in; OVERFLOW: hidden; WIDTH: 0.729in; POSITION: absolute; TOP:
2.958in; HEIGHT: 0.177in" tabIndex=11></TEXTAREA><SPAN
class=MSTheme-Label id=FUNDSOURCE_Label title="FUND SOURCE"
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 3.208in; HEIGHT: 0.177in">FUND
SOURCE</SPAN><TEXTAREA id="FUND SOURCE" title="FUND SOURCE" style="LEFT:
1.125in; OVERFLOW: hidden; WIDTH: 0.729in; POSITION: absolute; TOP:
3.208in; HEIGHT: 0.177in" tabIndex=12></TEXTAREA><SPAN
class=MSTheme-Label id=STATUS_Label title=STATUS
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 3.458in; HEIGHT: 0.177in">STATUS</SPAN><TEXTAREA
id=STATUS title=STATUS style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH:
0.729in; POSITION: absolute; TOP: 3.458in; HEIGHT: 0.177in"
tabIndex=13></TEXTAREA><SPAN
class=MSTheme-Label id=DATE(MONTH/YEAR)_Label title="DATE (MONTH/YEAR)"
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 3.708in; HEIGHT: 0.177in">DATE
(MONTH/YEAR)</SPAN><TEXTAREA id="DATE (MONTH/YEAR)" title="DATE
(MONTH/YEAR)" style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 1.604in;
POSITION: absolute; TOP: 3.708in; HEIGHT: 0.177in"
tabIndex=14></TEXTAREA><SPAN
class=MSTheme-Label id=REMARKS_Label title=REMARKS
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in;
POSITION: absolute; TOP: 3.958in; HEIGHT: 0.177in">REMARKS</SPAN><TEXTAREA
id=REMARKS title=REMARKS style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH:
3.167in; POSITION: absolute; TOP: 3.958in; HEIGHT: 0.583in"
tabIndex=15></TEXTAREA><SPAN
class=MSTheme-Label id=DropdownList0_Label title="PROJECT NO"
style="PADDING-LEFT: 1px; LEFT: 2.333in; OVERFLOW: visible; WIDTH: 1in;
POSITION: absolute; TOP: 0.125in; HEIGHT: 0.166in">PROJECT
NO</SPAN><SELECT id=SPROJECT title=DropdownList0
style="LEFT: 3.333in; WIDTH: 1in; POSITION: absolute; TOP: 0.125in; HEIGHT:
0.208in"
tabIndex=16></SELECT></DIV>
<DIV class=MicrosoftAccessBanner id=NavigationSectionTblProjectsBanner
style="BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP:
buttonhighlight 2px outset; DISPLAY: none; PADDING-LEFT: 1px; FONT-WEIGHT:
normal; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: buttonhighlight 2px
outset; WIDTH: 446px; BORDER-BOTTOM: buttonhighlight 2px outset;
FONT-FAMILY: Tahoma; HEIGHT: 0.2in; BACKGROUND-COLOR:
buttonface">NavigationSection:
TblProjects</DIV>
<DIV class=MSOShowDesignGrid id=NavigationSectionTblProjects
style="VISIBILITY: hidden; OVERFLOW: hidden; WIDTH: 446px; POSITION:
relative; HEIGHT: 35px; BACKGROUND-COLOR: transparent">
<OBJECT id=TblProjectsNavigation
style="LEFT: 8px; WIDTH: 438px; POSITION: absolute; TOP: 5px"
codeBase=P:\Off2K\En\msowc.cab
classid=CLSID:0002E531-0000-0000-C000-000000000046><PARAM NAME="_State"
VALUE=""><PARAM NAME="RecordSource" VALUE="TblProjects"><PARAM
NAME="RecordsetLabel" VALUE="TblProjects |0 of |2;TblProjects |0-|1 of
|2"><PARAM NAME="ShowFirstButton" VALUE="-1"><PARAM NAME="ShowPrevButton"
VALUE="-1"><PARAM NAME="ShowNextButton" VALUE="-1"><PARAM
NAME="ShowLastButton" VALUE="-1"><PARAM NAME="ShowNewButton"
VALUE="-1"><PARAM NAME="ShowDelButton" VALUE="-1"><PARAM
NAME="ShowSaveButton" VALUE="-1"><PARAM NAME="ShowUndoButton"
VALUE="-1"><PARAM NAME="ShowSortAscendingButton" VALUE="-1"><PARAM
NAME="ShowSortDecendingButton" VALUE="-1"><PARAM
NAME="ShowApplyFilterButton" VALUE="-1"><PARAM
NAME="ShowToggleFilterButton" VALUE="-1"><PARAM NAME="ShowHelpButton"
VALUE="-1"><PARAM NAME="ShowLabel" VALUE="-1"><PARAM NAME="FontName"
VALUE="Tahoma"></OBJECT></DIV>

<P> </P></BODY></HTML>
--------------------------------

So, it seems to be a simple procedure and normally I catch very quickly but why it's not working now?

Thanks for your help. It's very appreciated.

fneily · May 1, 2007

My computer must be messed up. Now I can post here.
I created a combobox using the wizard, from scratch and it works. Below is my code. Maybe you can find some difference:
The coding seems correct - SPROJECT is your combobox ID and [Project No] is your field name in the table. And it's only two lines of code.

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML XMLNS:o="urn:schemas-microsoft-com:office:office" 
XMLNS:x="urn:schemas-microsoft-com:office:excel" 
XMLNS:a="urn:schemas-microsoft-com:office:access" 
XMLNS:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:o = 
"urn:schemas-microsoft-com:office:office" xmlns:x = 
"urn:schemas-microsoft-com:office:excel" xmlns:a = 
"urn:schemas-microsoft-com:office:access" xmlns:dt = 
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>
employee_table_dap</TITLE><LINK 
href="./combobox_selection_files/filelist.xml" type=text/xml rel=File-List>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<STYLE id=MSODAPDEFAULTS type=text/css rel="stylesheet">.mstheme-label {
	FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
	FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
.msoboundhtml {
	FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
HR {
	COLOR: black
}
SELECT {
	FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
INPUT {
	FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BODY {
	FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
MARQUEE {
	FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
LEGEND {
	FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
.msoHyperlinkDisplayText {
	FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
	FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
.MsoShowDesignGrid {
	BEHAVIOR: url(#DEFAULT#MsoShowDesignGrid)
}
</STYLE>

<OBJECT id=MSODSC codeBase=D:\msowc.cab#version=9,0,0,2710 
classid=CLSID:0002E530-0000-0000-C000-000000000046><PARAM NAME="XMLData" 
VALUE="<xml 
xmlns:a=&quot;urn:schemas-microsoft-com:office:access&quot;>&#13;&#10; 
<a:DataSourceControl>&#13;&#10;  
<a:OWCVersion>9.0.0.2710</a:OWCVersion>&#13;&#10;  
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data 
Source=C:\test4.mdb;Mode=Share Deny None;Jet OLEDB:System 
database=&amp;quot;&amp;quot;;Jet OLEDB:Database 
Password=&amp;quot;&amp;quot;</a:ConnectionString>&#13;&#10;  
<a:MaxRecords>10000</a:MaxRecords>&#13;&#10;  
<a:GridX>24</a:GridX>&#13;&#10;  <a:GridY>24</a:GridY>&#13;&#10;  
<a:ElementExtension>&#13;&#10;   
<a:ElementID>employee_tableNavigation</a:ElementID>&#13;&#10;   
<a:ConsumesRecordset/>&#13;&#10;  </a:ElementExtension>&#13;&#10;  
<a:ElementExtension>&#13;&#10;   
<a:ElementID>employeeid</a:ElementID>&#13;&#10;   
<a:ControlSource>employeeid</a:ControlSource>&#13;&#10;   
<a:ChildLabel>employeeid_Label</a:ChildLabel>&#13;&#10;  
</a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   
<a:ElementID>firstname</a:ElementID>&#13;&#10;   
<a:ControlSource>firstname</a:ControlSource>&#13;&#10;   
<a:ChildLabel>firstname_Label</a:ChildLabel>&#13;&#10;  
</a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   
<a:ElementID>lastname</a:ElementID>&#13;&#10;   
<a:ControlSource>lastname</a:ControlSource>&#13;&#10;   
<a:ChildLabel>lastname_Label</a:ChildLabel>&#13;&#10;  
</a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   
<a:ElementID>amount</a:ElementID>&#13;&#10;   
<a:ControlSource>amount</a:ControlSource>&#13;&#10;   
<a:ChildLabel>amount_Label</a:ChildLabel>&#13;&#10;  
</a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   
<a:ElementID>EntryDate</a:ElementID>&#13;&#10;   
<a:ControlSource>EntryDate</a:ControlSource>&#13;&#10;   
<a:ChildLabel>EntryDate_Label</a:ChildLabel>&#13;&#10;  
</a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   
<a:ElementID>initialfield</a:ElementID>&#13;&#10;   
<a:ControlSource>initialfield</a:ControlSource>&#13;&#10;   
<a:ChildLabel>initialfield_Label</a:ChildLabel>&#13;&#10;  
</a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   
<a:ElementID>yesorno</a:ElementID>&#13;&#10;   
<a:ControlSource>yesorno</a:ControlSource>&#13;&#10;   
<a:ChildLabel>yesorno_Label</a:ChildLabel>&#13;&#10;  
</a:ElementExtension>&#13;&#10;  <a:ElementExtension>&#13;&#10;   
<a:ElementID>shanum</a:ElementID>&#13;&#10;   
<a:ListRowSource>employee_table</a:ListRowSource>&#13;&#10;   
<a:ListBoundField>employeeid</a:ListBoundField>&#13;&#10;   
<a:ListDisplayField>employeeid</a:ListDisplayField>&#13;&#10;   
<a:ChildLabel>DropdownList1_Label</a:ChildLabel>&#13;&#10;  
</a:ElementExtension>&#13;&#10;  <a:GroupLevel>&#13;&#10;   
<a:RecordSource>employee_table</a:RecordSource>&#13;&#10;   
<a:DefaultSort>[employeeid] ASC</a:DefaultSort>&#13;&#10;   
<a:HeaderElementId>Headeremployeetable</a:HeaderElementId>&#13;&#10;   
<a:FooterElementId></a:FooterElementId>&#13;&#10;   
<a:CaptionElementId></a:CaptionElementId>&#13;&#10;   
<a:RecordNavigationElementId>NavigationSectionemployeetable</a:
RecordNavigationElementId>&#13;&#10;   
<a:DataPageSize>1</a:DataPageSize>&#13;&#10;  </a:GroupLevel>&#13;&#10;  
<a:Datamodel version=&quot;0816&quot;>&#13;&#10;   <a:SchemaRowsource 
id=&quot;employee_table&quot; type=&quot;dscTable&quot;>&#13;&#10;    
<a:SchemaField id=&quot;employeeid&quot; datatype=&quot;202&quot; 
size=&quot;50&quot; iskey=&quot;1&quot;/>&#13;&#10;    <a:SchemaField 
id=&quot;firstname&quot; datatype=&quot;202&quot; 
size=&quot;50&quot;/>&#13;&#10;    <a:SchemaField id=&quot;lastname&quot; 
datatype=&quot;202&quot; size=&quot;25&quot;/>&#13;&#10;    <a:SchemaField 
id=&quot;amount&quot; datatype=&quot;6&quot; size=&quot;0&quot;/>&#13;&#10;    
<a:SchemaField id=&quot;EntryDate&quot; datatype=&quot;7&quot; 
size=&quot;0&quot;/>&#13;&#10;    <a:SchemaField 
id=&quot;initialfield&quot; datatype=&quot;202&quot; 
size=&quot;50&quot;/>&#13;&#10;    <a:SchemaField id=&quot;yesorno&quot; 
datatype=&quot;202&quot; size=&quot;50&quot;/>&#13;&#10;   
</a:SchemaRowsource>&#13;&#10;   <a:RecordsetDef 
id=&quot;employee_table&quot;>&#13;&#10;    <a:PageField 
id=&quot;employeeid&quot;/>&#13;&#10;    <a:PageField 
id=&quot;firstname&quot;/>&#13;&#10;    <a:PageField 
id=&quot;lastname&quot;/>&#13;&#10;    <a:PageField 
id=&quot;amount&quot;/>&#13;&#10;    <a:PageField 
id=&quot;EntryDate&quot;/>&#13;&#10;    <a:PageField 
id=&quot;initialfield&quot;/>&#13;&#10;    <a:PageField 
id=&quot;yesorno&quot;/>&#13;&#10;   </a:RecordsetDef>&#13;&#10;  
</a:Datamodel>&#13;&#10; 
</a:DataSourceControl>&#13;&#10;</xml>'&quot;"></OBJECT>
<META content="MSHTML 6.00.2600.0" name=GENERATOR><!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>Neil</o:Author>
  <o:LastAuthor>Neil</o:LastAuthor>
  <o:Revision>3</o:Revision>
  <o:TotalTime>2</o:TotalTime>
  <o:Created>2007-05-01T10:37:56Z</o:Created>
  <o:LastSaved>2007-05-01T10:47:29Z</o:LastSaved>
  <o:Company>CCBC</o:Company>
  <o:Version>9.2720</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:DownloadComponents/>
  <o:LocationOfComponents HRef="file:D:\msowc.cab"/>
 </o:OfficeDocumentSettings>
</xml><![endif]-->
<SCRIPT language=vbscript event=onchange for=shanum>
<!--
Dim rs
Set rs = MSODSC.DefaultRecordset

rs.Find "[employeeid] = '" & document.all.item("shanum").value & "'", 0, 1, 1

    '0 = Skip zero records before starting the search.
    '1 = Search in a forward direction.
    '1 = Always begin the search with the first record in the recordset.

-->
</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" bottomMargin=48 vLink=#800080 link=#800080 
leftMargin=24 topMargin=24 rightMargin=24>
<CENTER>
<H1 id=HeadingText style="FONT-WEIGHT: normal">Testing 
ComboBox&nbsp;</H1></CENTER>
<P>&nbsp;</P>
<DIV class=MicrosoftAccessBanner id=HeaderemployeetableBanner 
style="BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; PADDING-LEFT: 1px; FONT-WEIGHT: normal; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: buttonhighlight 2px outset; WIDTH: 464px; BORDER-BOTTOM: buttonhighlight 2px outset; FONT-FAMILY: Tahoma; HEIGHT: 0.2in; BACKGROUND-COLOR: buttonface">Header: 
employee_table</DIV>
<DIV class=MSOShowDesignGrid id=Headeremployeetable 
style="VISIBILITY: hidden; OVERFLOW: hidden; WIDTH: 464px; POSITION: relative; HEIGHT: 2.115in; BACKGROUND-COLOR: transparent"><SPAN 
class=MSTheme-Label id=employeeid_Label title=employeeid 
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in; POSITION: absolute; TOP: 0.333in; HEIGHT: 0.177in">employeeid</SPAN><TEXTAREA id=employeeid title=employeeid style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 1.604in; POSITION: absolute; TOP: 0.333in; HEIGHT: 0.177in" tabIndex=1></TEXTAREA><SPAN 
class=MSTheme-Label id=firstname_Label title=firstname 
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in; POSITION: absolute; TOP: 0.583in; HEIGHT: 0.177in">firstname</SPAN><TEXTAREA id=firstname title=firstname style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 1.604in; POSITION: absolute; TOP: 0.583in; HEIGHT: 0.177in" tabIndex=2></TEXTAREA><SPAN 
class=MSTheme-Label id=lastname_Label title=lastname 
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in; POSITION: absolute; TOP: 0.833in; HEIGHT: 0.177in">lastname</SPAN><TEXTAREA id=lastname title=lastname style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 1.344in; POSITION: absolute; TOP: 0.833in; HEIGHT: 0.177in" tabIndex=3></TEXTAREA><SPAN 
class=MSTheme-Label id=amount_Label title=amount 
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in; POSITION: absolute; TOP: 1.083in; HEIGHT: 0.177in">amount</SPAN><TEXTAREA id=amount title=amount style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 1.604in; POSITION: absolute; TOP: 1.083in; HEIGHT: 0.177in" tabIndex=4></TEXTAREA><SPAN 
class=MSTheme-Label id=EntryDate_Label title=EntryDate 
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in; POSITION: absolute; TOP: 1.375in; HEIGHT: 0.177in">EntryDate</SPAN><TEXTAREA id=EntryDate title=EntryDate style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 0.677in; POSITION: absolute; TOP: 1.375in; HEIGHT: 0.177in" tabIndex=5></TEXTAREA><SPAN 
class=MSTheme-Label id=initialfield_Label title=initialfield 
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in; POSITION: absolute; TOP: 1.625in; HEIGHT: 0.177in">initialfield</SPAN><TEXTAREA id=initialfield title=initialfield style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 1.604in; POSITION: absolute; TOP: 1.625in; HEIGHT: 0.177in" tabIndex=6></TEXTAREA><SPAN 
class=MSTheme-Label id=yesorno_Label title=yesorno 
style="PADDING-LEFT: 1px; LEFT: 0.042in; OVERFLOW: visible; WIDTH: 1.083in; POSITION: absolute; TOP: 1.875in; HEIGHT: 0.177in">yesorno</SPAN><TEXTAREA id=yesorno title=yesorno style="LEFT: 1.125in; OVERFLOW: hidden; WIDTH: 1.604in; POSITION: absolute; TOP: 1.875in; HEIGHT: 0.177in" tabIndex=7></TEXTAREA><SPAN 
class=MSTheme-Label id=DropdownList1_Label title=employeeid_selection 
style="PADDING-LEFT: 1px; LEFT: 0.083in; OVERFLOW: visible; WIDTH: 1in; POSITION: absolute; TOP: 0.042in; HEIGHT: 0.166in">employeeid_selection</SPAN><SELECT 
id=shanum title=DropdownList1 
style="LEFT: 1.25in; WIDTH: 0.792in; POSITION: absolute; TOP: 0.042in; HEIGHT: 0.208in" 
tabIndex=8></SELECT></DIV>
<DIV class=MicrosoftAccessBanner id=NavigationSectionemployeetableBanner 
style="BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; PADDING-LEFT: 1px; FONT-WEIGHT: normal; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: buttonhighlight 2px outset; WIDTH: 464px; BORDER-BOTTOM: buttonhighlight 2px outset; FONT-FAMILY: Tahoma; HEIGHT: 0.2in; BACKGROUND-COLOR: buttonface">NavigationSection: 
employee_table</DIV>
<DIV class=MSOShowDesignGrid id=NavigationSectionemployeetable 
style="VISIBILITY: hidden; OVERFLOW: hidden; WIDTH: 464px; POSITION: relative; HEIGHT: 35px; BACKGROUND-COLOR: transparent">
<OBJECT id=employee_tableNavigation 
style="LEFT: 8px; WIDTH: 456px; POSITION: absolute; TOP: 5px" 
codeBase=D:\msowc.cab#version=9,0,0,2710 
classid=CLSID:0002E531-0000-0000-C000-000000000046><PARAM NAME="_State" 
VALUE=""><PARAM NAME="RecordSource" VALUE="employee_table"><PARAM 
NAME="RecordsetLabel" VALUE="employee_table |0 of |2;employee_table |0-|1 
of |2"><PARAM NAME="ShowFirstButton" VALUE="-1"><PARAM 
NAME="ShowPrevButton" VALUE="-1"><PARAM NAME="ShowNextButton" 
VALUE="-1"><PARAM NAME="ShowLastButton" VALUE="-1"><PARAM 
NAME="ShowNewButton" VALUE="-1"><PARAM NAME="ShowDelButton" 
VALUE="-1"><PARAM NAME="ShowSaveButton" VALUE="-1"><PARAM 
NAME="ShowUndoButton" VALUE="-1"><PARAM NAME="ShowSortAscendingButton" 
VALUE="-1"><PARAM NAME="ShowSortDecendingButton" VALUE="-1"><PARAM 
NAME="ShowApplyFilterButton" VALUE="-1"><PARAM 
NAME="ShowToggleFilterButton" VALUE="-1"><PARAM NAME="ShowHelpButton" 
VALUE="-1"><PARAM NAME="ShowLabel" VALUE="-1"><PARAM NAME="FontName" 
VALUE="Tahoma"></OBJECT>
</DIV>
<P>&nbsp;</P></BODY></HTML>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How to Find a Record from a Drop-down List in a Data Access Page 1

Techniproshop

Programmer

fneily

Instructor

Techniproshop

Programmer

fneily

Instructor

Techniproshop

Programmer

fneily

Instructor

Similar threads

Part and Inventory Search

Sponsor