[mcRon]

Is there a way to populate a listbox in a form with data from an Access 2003
query? I have a simple query with a list of branch locations and I would
like to create a form with a listbox to select the location. I have more
than 25 locations so I cannot populate the listbox manually. I would like
the listbox to reflect new entries to the table/query as it is updated.

Thanks for the help,
McR

[Greg Maxey]

Ron,

You might be able to make one of the methods shown here to work:

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

See the piece on external data sources.



On Apr 9, 11:50 am, mcRon wrote:
Is there a way to populate a listbox in a form with data from an Access 2003
query? I have a simple query with a list of branch locations and I would
like to create a form with a listbox to select the location. I have more
than 25 locations so I cannot populate the listbox manually. I would like
the listbox to reflect new entries to the table/query as it is updated.

Thanks for the help,
McR

[mcRon]

Thanks for the brainpower. That should do the trick...

McR

"Greg Maxey" wrote:

Ron,

You might be able to make one of the methods shown here to work:

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

See the piece on external data sources.



On Apr 9, 11:50 am, mcRon wrote:
Is there a way to populate a listbox in a form with data from an Access 2003
query? I have a simple query with a list of branch locations and I would
like to create a form with a listbox to select the location. I have more
than 25 locations so I cannot populate the listbox manually. I would like
the listbox to reflect new entries to the table/query as it is updated.

Thanks for the help,
McR