You are here:

Using MS Access/combo box in ms access 2003

Advertisement

Expert: Manish Batola - 4/8/2009


Question
hello, manish.
thank you for taking the time to look at this question.
i am having issues with combo boxes that not only update in the current record when i choose a value - - they change the data in all the records.  how can i set them up so that if i am in record 6 and i choose a value, it is retained in that field only in that record?

Answer
Hi Desiree,

Infact I'm not to clear which values you change and where. I assume that once data in the combo box is changed it triggers an update query running behind it to makes changes to values in your entire database.
You need to check that query in your trigger and change its parameter values from all records to current record.
Probably you can send me a visual screen shot of your form on aqantassoftware@rediffmail.com so I can have a clear understanding.

Best regards,
Manish Batola.

Using MS Access

All Answers

Answers by Expert:

Ask Experts

Volunteer

Manish Batola

Expertise

ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),HSE-Health,Safety & Environmental Applications,School Management Systems,Hotel Software, Hospital Software,Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions, Industrial Strength Invoicing and many more being added every year.

Experience

26+ yrs in the Software industry with 19yrs completely dedicated on more than 300 Various Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.

Organizations
Worked in various multinationals catering from Aerospace, Oil & Gas etc.

Education/Credentials
-MSAP (Master in Software & Applications Programming) -BPRE (Business Process Re-engineering Engineer) -SQAE (Software Quality Assurance Engineer) -STIE (Software Testing & Inspection Engineer) -Project Engineeer (Software Development)

Past/Present Clients
Catered to various clients in the following industries • Oil & Natural Gas (BPM/CRM/Access Development) • Sales / Marketing (CRM) • Automotive (Automobile Dealers) • Logistics & Indenters (Import/Export) • HealthCare / Hospitals • Hotels 3* & 5* • Restaurants • Construction Co’s (Project Billing) • Clubs (Concept Selling) • Shoe-Chains • Solicitors/Lawyers • Call Centers • Aerospace (Preventive Maintenance) • Travel & Tourism • Computer Vendors • Manufacturing • Music Shops • Education • Data Warehousing • Health,Safety & Environmental Applications • Mud Engineering • School Management Software

©2012 About.com, a part of The New York Times Company. All rights reserved.