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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing value of other table 5
Lag on dropdown action, when values change? 2
clearing recordsource on close/unload not working 5
No duplicates in Combobox 3
Access 2003: populate combobox with CSV values from table column 1
referring to a field in a datasheet form 3
ComboBox 1
How do i get the value from a comboxbox and link it to print. 0

Back
Top