X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Form Wont Allow Data Entry, Access 2016    
post May 31 2020, 11:55 AM

Posts: 77
Joined: 20-November 16

hello chaps,
perhaps someone can help
I have a database with one table ,one query and one form
a combo box in the header allows me to select a record in the query and this record is then displayed in the form.
but some of the fields in the form will not allow data entry.
I have tried creating another form using the form wizard and the same query and in this case all the records update
with no problem.
where should i start looking in the original form to try and find the problem.?

I dont particulary want to redo the form because i dont want to lose the formatting

I have googled the problem but havent found an answer that works.

can anyone help please?


Go to the top of the page
post May 31 2020, 12:05 PM

UA Admin
Posts: 37,447
Joined: 20-June 02
From: Newcastle, WA

"...but some of the fields in the form will not allow data entry."

What happens when you try to type an entry in those controls?

My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
tina t
post May 31 2020, 12:10 PM

Posts: 6,671
Joined: 11-November 10
From: SoCal, USA

you can check the Enabled property and Locked property of each of the problem controls. to allow you to add/edit/delete data in each control, its' properties must be set as

Enabled = True
Locked = False

also check your macros and/or VBA code to see if you have set either/both of the above properties to the opposite, for the problem controls.


"the wheel never stops turning"
Go to the top of the page
post May 31 2020, 12:15 PM

Posts: 1,099
Joined: 21-September 14
From: Tampa, Florida USA

Unless you specified a FormOpenDataMode that doesn't allow add or edit, then check the field properties that Tina mentioned.


Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix, Oracle & PostgreSQL db's.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    4th July 2020 - 01:44 PM