Dropdown boxes won't show value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top