Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / November 2005

Tip: Looking for answers? Try searching our database.

Combo Box Question/Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David W - 30 Nov 2005 22:06 GMT
I have got an unbound combobox that has a recordsource of a field in a
table, when you select a name from the combobox, it stores that name in a
textbox when you click on a save button. That does fine!

Problem
When I open the form and edit an existing record, I am trying to to put the
name into that Combo Box for display purposes only by code and I get an
error stating that its not the right value for the control.
Both fields from the different tables are set to text for the field
properties.
There is no formating in place on either boxes.

code example
to populate the textbox
me.textbox1 = me.combo1

to populate the combo box
me.combo1 = me.textbox1

Reversed order from which the textbox was populated.

Whats going on?
David W
Mark A. Sam - 30 Nov 2005 23:16 GMT
Just a thought... Try placing the code in the Current Event of the form.

God Bless,

Mark A. Sam

> I have got an unbound combobox that has a recordsource of a field in a
> table, when you select a name from the combobox, it stores that name in a
[quoted text clipped - 19 lines]
> Whats going on?
> David W
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.