how do i enter info into a field in a form when it doesn't allow

N

Nancy Philip

I tried entering some data in the field in the form and certain fields either
allow me to click in the box but doesnt allow me to enter anything and some
dont even allow me to click in the fields either to enter anything. How do i
solve that?
 
B

Brian Bastl

What is the recordsource for the form? Are you joining multiple tables?
Also, is the form's AllowEdits property set to NO? Is there code in the
form's On Current event which would prevent data entry? Could be any number
of reasons.

Brian
 
O

Ofer

Open the form in design view, check the field properties
If the properties are

1. Locked = True
You can enter the field but you can't edit

2. Enable = False
You can't enter and edit the field

3. If there is a formula in the control source of the field, you can enter
but you can't edit
formula like =[Field1]+[Field2]
 
N

Nancy Philip

what should i check for in the properties of the form to make sure that i can
enter something because i'm working on a database that i never created so i
have no idea about the actual fundamentals of the database created as far as
if there are multiple tables joined or not..is there any thing in particular
that I should be looking for to know where exactly the problem lies? thanx
 
B

Brian Bastl

In addition to what Ofer said to look for, click on the "All" tab, and look
at the recordsource. Does it specify a table name, or do you see something
like "SELECT * FROM ... " If so, click the the button directly to the right
[...]. This will open the query builder. Is there only one table showing in
the pane, or are there two or more tables with lines connecting them? If you
only see one table or query listed, then you'll have to look elsewhere. On
the same tab of the form's property sheet, look for ALLOW EDITS, ALLOW
ADDITIONS, DATA ENTRY, etc...
The attributes should be:
Allow Edits = Yes
Allow Additions = Yes
Allow Deletions = Yes
Data Entry = No

If that doesn't solve your problem, then click on the "Events" tab. Are
there any listed events with [Event Procedure] on the line? If so, click the
ellipse button [...] to open the vba editor. Look for anything that has
either an .Enabled or .Locked reference.

Brian
 
Top