Open Table based on combobox selection

  • Thread starter Thread starter irbtastic
  • Start date Start date
I

irbtastic

Hello,

I have an unbound form on which I would like to create a combobox that has a
list of certain tables in my db (2 columns, first column is the table name
alias and the 2nd column is the actual table name).

I would like the user to select one table name alias from the list of tables
in the combo box and click an 'OK' button that will trigger an event
procedure to open the specific table that the user selected.

Is this possible? Does anyone know how to do this?

Thank you in advance!
Emily
 
You should never give users access to the tables! They should always use
forms. Why do you wish to do this?

Now to answer you question, even though i would highly suggest you rethink
this. try something like:

DoCmd.OpenTable forms![FormName].Form.ComboBoxName.Column(1), acViewNormal

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Thank you! This works perfectly.

Daniel Pineault said:
You should never give users access to the tables! They should always use
forms. Why do you wish to do this?

Now to answer you question, even though i would highly suggest you rethink
this. try something like:

DoCmd.OpenTable forms![FormName].Form.ComboBoxName.Column(1), acViewNormal

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



irbtastic said:
Hello,

I have an unbound form on which I would like to create a combobox that has a
list of certain tables in my db (2 columns, first column is the table name
alias and the 2nd column is the actual table name).

I would like the user to select one table name alias from the list of tables
in the combo box and click an 'OK' button that will trigger an event
procedure to open the specific table that the user selected.

Is this possible? Does anyone know how to do this?

Thank you in advance!
Emily
Click to expand...
Click to expand...
 
Back
Top