Form List as Rowsource for ComboBox

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I am trying to make a combobox display a list of the forms
in my database. I cannot seem to get the coding correct
to set the list as the rowsource.

Bassically I am trying to use one command button to open
all forms. The code for the command button opens the form
name displayed in the combobox. I have got it to work
with a textbox where I manually type in the form name, but
as yet I am unsuccessful in referencing the forms in the
combobox.

Thanks for the help.
 
Rob-

Take a look at:

ftp://ftp.viescas.com/Download/DBContainerV9.mdb (an Access 2000 database)

It has a form that "emulates" the database window by loading objects into a
list box. You should be able to adapt the code for your use to load a Value
List into a combo box.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Thanks John
-----Original Message-----
Rob-

Take a look at:

ftp://ftp.viescas.com/Download/DBContainerV9.mdb (an Access 2000 database)

It has a form that "emulates" the database window by loading objects into a
list box. You should be able to adapt the code for your use to load a Value
List into a combo box.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)



.
Click to expand...
 
Back
Top