You are here:

Using MS Access/Form property DataEntery=Yes prevents fields be filled out automatically


I have a main form with a subform. Both forms' properties are set to DataEntry=Yes (user must see a blank record when the form is opened). The source for the main form is a query with one table. A subform is based out of another query (table). Both tables linked by FP-PK. On the main form there is a combobox (dropdown) with a couple of other fields that are filled out automatically based on the selection in this dropdown. Everything works fine but as soon as the form property is set to DataEntry=Yes the fields that are supposed to be filled out atomatically based on the selection from the dropdown remain blank on the main form. Any hints of how to overcome this problem?

Hi Oleg,
When you set a property such as dataEntry = Yes, it will open the form with blank fields for data entry. Under this circumstance if you want some fields to be filled out automatically then you need to specify some default values PER FIELD. This will fetch those default values when your form loads.
That's one hint which comes to my mind immediately.

Pls try it and do let me know.

Best regards
Manish Batola  

Using MS Access

All Answers

Answers by Expert:

Ask Experts


Manish Batola


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.


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

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

-BSc - Computer Science -MSAP (Master in Software & Applications Programming) -BPRE (Business Process Re-engineering Engineer) -SQAE (Software Quality Assurance Engineer) -STIE (Software Testing & Inspection Engineer) -Project Engineer (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

©2016 All rights reserved.