Missing entries in table

[JamesN]

Hi,

I'm using a form to add new records to a table. The issue I am having is that all of the entries from the form are being added as a new record to the table minus one, for some reason it leaves the column in the warehouse blank. On some instances it adds the data correctly but not always. Is there any reason for this as not getting any errors showing?

Thanks

 

[Ranman256]

It could be the table relationship excludes it.
It could be the table keys, excluding it.

 

[stopher]

Another thought...

If you enter text with line feeds then your text could be input as more than one line with the actual text not visible. It's easy to check this by opening your table and increasing the row height to see if there is text further in the "cell".

 

[missinglinq]

Is this a Bound Form...an Unbound Form? If the latter, exactly how are you adding this data?

Linq ;0)>

 

[The_Doc_Man]

When the "drop" occurs, is it always the last record entered?