var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: code to update list box
I have a list box on a access form and would like it to update everytime the focus is set to the form. What code would I need to do this?
Can you try this and let me the result.
Private Sub Form_Activate()
I think you should just requery your listbox as the form gets the focus
peter_2950, you're just repeating my question. Do you have a solution?
sorry gave it a try and nothing worked
Public Function RequeryMainSubform()
strFullSQL = "Select * From goody " & strWhereSQL
Me!subQueryByForm.Form.RecordSource = strFullSQL
Where subQueryByForm is the subForm to display the data.
You could try Me!ListBox.Requery in the On Got Focus event of the form.