Small Access Error message

[NigelShaw]

Hi,

i seem to be geting this message ( attached ) everytime i load the form for the first time. once i click ok, i can the enter data into the field and save as normal. if i load the form and got to a different field, it seems to be ok and the mesaage does not come back but it is definately there when i first click in the same field.

i have checked the form properties, field properties and code but i cannot see anything.

what usually causes this?

the text is the right size
the form is not in design view

i cant seem to find if the field is read only but after the box, i can enter data so that should remove any read only issues.

its vv frustrating.


regs,

Nigel

 

[valheru]

Hi Nigel

This error message usually occurs in the following instances ( someone correct me if i'm wrong ):

1. You are trying to assign a value to a control which does not accept values.
2. You are trying to assign a value to a control which is out of the acceptable range specified. So for instance you have decalred Variable1 as an integer and you try and assign a text value to it.

If you want, attach the db with the form causing the issues and i'll see if I can help.

 

[NigelShaw]

Hi,

i checked the field values but all is normal. when i open the form on its own, i do not get an error. the form usually opens as a subform on a main form. this is where i get the problem.

my db is quite large and i would be a little hesitant to post it only as i would have a bit of work to make it raw etc.

i can post the form only as a db but like i said, it works fine on its own so it has to be a subform issue.

i will take a look at the " new record " element as this is what it does when the subform opens.


regards,

Nigel

 

[Rabbie]

Are the form and subform bound to the same query? If so is that query allowing updates? Did you use the wizard to install the subform on the form? Without seeing your DB it is a little difficult to give you a specific reason for the error.