Dropdown boxes won't show value

message from =?Utf-8?B?VGFzaGE=?= on 27 May 2004
I followed the MS Access performance FAQ to the link below. This link is about loading the queries for a form, combobox,etc. at runtime to help improve performance. I attempted to implement this. I was able to get this to work. However, when I load the rowsource for the comboboxes instead of the value from the table the form is connected to showing the value is blank. If I click on the dropdown box the correct value is highlighted and will then show and the dropdown box is populated properly. Is there anyway to work around this to make the value in the table show on load?

http://www.granite.ab.ca/access/performanceforms.htm
 
=?Utf-8?B?VGFzaGE=?= replied to =?Utf-8?B?VGFzaGE=?= on 28 May 2004
I found a solution to my problem and thought I would post it in case any one else has same problem.
after

Private Sub Form_Load()

me.recordsource = "query"
me.mycontrol1.rowsource = "somequery"
me.mycontrol1.value = me.mycontrol1.value (add this line)

End Sub
 

Archived message: Dropdown boxes won't show value (Microsoft Access Error Message)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.