Re: Blank Listbox

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Joy,
My question would be... why would the links be broken?
Also, seeing the exact "re-linking" code you refer to would be helpful.

But... just off the top, it sounds like the code you refer to isn't
doing a listbox Requery after the link is refreshed.
By going into design mode, and then re-opening the form, your just
manually forcing a listbox Requery.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Joy" <ongshat@xxxxxxxxx> wrote in message
news:%23p3G8lnxIHA.2340@xxxxxxxxxxxxxxxxxxxxxxx

Hi,
I have a database in Access 2003 split into a front and back-end.

On the opening form of the front-end, there is a tab control that has an
unbound listbox in it. If the table links are broken, there is VBA code
called from the opening form that re-links the tables and continues to
open the form.

My problem is when the links are refreshed with the code and the form
opens the listbox in the tab control is blank. If I close the database
and reopen it or change the form view to design view then back to form
view, the listbox is fine and is populated correctly.

Can anyone tell my why?

Thanks in advance.
Joy



.

Relevant Pages

  • Re: multi-select listbox question
    ... > You can use the Column property to refer to a specific column, ... > control A Control object that represents the active combo box or ... > selection has been made, ... >> listbox has to be the column that holds the prices - at least i couldn't ...
    (microsoft.public.access.forms)
  • listbox data from a closed file
    ... With the macro below you can fill a ListBox control with input from ... another closed workbook. ... The macro opens the closed workbook without the user noticing it, ... Dim dbConnection As ADODB.Connection, rs As ADODB.Recordset ...
    (microsoft.public.excel.misc)
  • GetOpenFilename type mismatch
    ... When the user clicks a button on the worksheet I have the the userform ... When I try to add the names to the ListBox I get runtime error 13 - ... If the Open dialog box opens and I just ... click open without selecting a file it will sometimes put the default ...
    (microsoft.public.excel.programming)
  • RE: More on List Boxes
    ... When i open the form it says it can not find the macro "Me". ... Listbox 1 name = AccountListBox ... I just ckick on OK without entering any parameter and the form opens. ... In the OnClick event write the code ...
    (microsoft.public.access.forms)
  • RE: Selecting columns from a query by using a form
    ... refers to a control on the currently active form or report. ... you have code behind a form or a control on the form, you can refer to any ... not what you see in the listbox. ... Fieldname where Fieldname is a text of the name of the column to be ...
    (microsoft.public.access.forms)