Unable to enter data into field (1 Viewer)

[poohbear2012]

When trying to enter a Customer ID into a form field it doesn't allow entry. I have checked all the settings and it is enabled and unlocked and all other fields on the form accept entry okay. This still happens when I remove and then readd the field, or add it as a combo box using the design ribbon.

Any suggestions as what could be preventing the entry, as have tried everything I can think of. I am using Microsoft Access 2010.

Many thanks
Trisha

 

[John Big Booty]

Is the Customer ID an AutoNuber by any chance?

 

[poohbear2012]

No it is a Text field with an Input mask.

 

[vbaInet]

What is the Control Source of the control? I suspect it's calculated.

 

[poohbear2012]

The record source for the field is coming from a query which includes the CustomerID from the tblsalesorders table. The field has worked in other forms, so not sure if it could be the set up of the customerID in this particular table.

 

[vbaInet]

I'm talking about the Control Source of the control, not the Record Source of the form. Let's see both anyway.

 

[poohbear2012]

Attached is a copy of the form and associated tables and query's.

 

[vbaInet]

What control are you referring to?

 

[poohbear2012]

CustomerID

 

[vbaInet]

The Record Source of your form is Read-Only. You can't present both tables on one form like that. You need a subform for your SaleOrders table. To be honest, I would advise you read up on normalisation.