UtterAccess.com
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    
 
   
ntambomvu
post May 31 2020, 11:55 AM
Post#1



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?

regards

fred
Go to the top of the page
 
GroverParkGeorge
post May 31 2020, 12:05 PM
Post#2


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
Post#3



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.

hth
tina

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



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.

https://docs.microsoft.com/en-us/office/vba...ormopendatamode

--------------------
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