Error When Entering Data in a Subform

[Mike3670]

I have created a form that allows viewing, editing and adding records to the
main table in the database. I have also created a subform that connects with
a different table that relates to the main table in a one-to-many
relationship, i.e. service notes relating to equipment table through the
serial number.

When creating a new record, upon typing the first character in any field an
error is returned stating that "Visual Basic can't convert the datatype of
one of the arguments you entered".

What's the issue and what's the fix?

 

[golfinray]

You may have more than one problem. First, is your subform linked to your
mainform? Second, is your subform editable? Third, datatype could be the
issue. If you form is expecting text and the field in the second table is set
to number or date you will get an error.

 

[Mike3670]

1. I belive the forms are linked. the subform is embedded in the mainform.
How would I check? 2. I checked the properties on the subform and as far as
I can tell it is set to be edited. 3. I checked the datatypes in the table
and the form and they match.

The error only occurs when the subform is embedded in the mainform. When I
open the subform separately, it does not show the error.

 

[golfinray]

Are the asterisk and arrow at the bottom of the subform highlighted or grayed
out?

 

[Mike3670]

Neither. They are normal appearance.

Are the asterisk and arrow at the bottom of the subform highlighted or grayed
out?