Form Help

[jimd1768]

I have a form that adds customer details. In the billing address it will not allow me to input anything.
Nothing types at all.

Does anyone have any posible solution for this. I have attached a picture to demonstrate

Thank you

 

[PNGBill]

Have you checked the Forms Properties? The top left hand of the Form and Right Click.
Check that Additions are allowed. Play with some settings and see what effect it has. Use a copy Database or remember where they were first.

 

[PNGBill]

If it is just the one Control on your form that won't allow you to Edit then in Design View, Right click on that Control (field) and check if it is Locked. Look under the Data Tab.

 

[jimd1768]

Thank you for the response.
It does allow additions and the field is not locked.

Not sure what to do.

 

[boblarson]

Is all this information in a single table or do you have multiple tables you are trying to add information to with one query as the form's recordsource?

 

[MoxieCraz]

I was going to ask the same question as Bob. Assuming that there are more than one table in your source query, check the join between the tables. (right click on the join)

 

[jimd1768]

Thanks to Bob & MoxieCraz. I made a basic error in the query. I was looking for ZipCode in the form but had PostCode in the customer table.

Thanks for responding. One day I will get it right....