Have a serious problem with a VB form based on a access DB using ADO

Data Bases , VB.NET , ADO , DB Jerusalem, Israel
  • 11 years ago

    I have a form that is connected to a access DB. The for displays emaployess in a chain of stores. I have two tables the form is based on: an Employees table and a cities table. the tables are joined on the cityCode field. I have combobox on my form whose value member is the cityCode and the siplay member is the cityName. When I try to select a city from the combobox it acts as a look- up and takes me to the record that has that city instead of just changing the city for that specific employee. Any suggestions how I can fix this? is there a property that I change so that it doesnt work as a look-up?

    I really appreciate it! Thanks for taking your time to read my question

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“I invented the term Object-Oriented, and I can tell you I did not have C++ in mind.” - Alan Kay