Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to read the selected combo box item.

Status
Not open for further replies.

londonkiwi

Programmer
Sep 25, 2000
83
NZ
My users select an Access DB (path and name held in the string gf_strDBPath). Then, via a combo box, my users are given the option to select an (Access DB) Table from all available tables in that DB. I want to get that selected Table eg. "TableName" hold it in a string and use it elsewhere, eg

Set rsLoad = dbLoad.OpenRecordset("TableName",dbOpenDynaset")

'cause I need to write data to it.

So an code relating to how to do it?

The combo box has is named "cboTables"

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top