MI problem

[Guest]

My form only has about 5 entries, First name, Last name, MI, Bus Phone, Bus
Fax. When I tab to MI, I get a beep and an error message saying, "Control
cannot be edited; it's bound to unknown field, 'MI.'"

What happens is when I begin to input data in the first name field, the MI
field automatically gets selected with #Na in it. When I tab to put in a
middle initial, I get a beep and the above error message in the status bar.

Please help.

 

[John Vinson]

My form only has about 5 entries, First name, Last name, MI, Bus Phone, Bus
Fax. When I tab to MI, I get a beep and an error message saying, "Control
cannot be edited; it's bound to unknown field, 'MI.'"

I wonder if you've perhaps used a Field named [MI], but set the
Control Source of your form textbox to [MI.]. The period makes this a
different field name, and Access cannot find a table field named
[MI.].

John W. Vinson[MVP]

 

[Guest]

Thanks for your prompt reply. Please explain what you mean by "but set the
Control Source of your form textbox to [MI.]."

My form only has about 5 entries, First name, Last name, MI, Bus Phone, Bus
Fax. When I tab to MI, I get a beep and an error message saying, "Control
cannot be edited; it's bound to unknown field, 'MI.'"

I wonder if you've perhaps used a Field named [MI], but set the
Control Source of your form textbox to [MI.]. The period makes this a
different field name, and Access cannot find a table field named
[MI.].

John W. Vinson[MVP]

 

[Guest]

Just figured out what you may have meant. Went back to the table and found
the field was entered as MiddleName. The form was labeled MI for that field.
This cleared the problem. Thanks.

My form only has about 5 entries, First name, Last name, MI, Bus Phone, Bus
Fax. When I tab to MI, I get a beep and an error message saying, "Control
cannot be edited; it's bound to unknown field, 'MI.'"

I wonder if you've perhaps used a Field named [MI], but set the
Control Source of your form textbox to [MI.]. The period makes this a
different field name, and Access cannot find a table field named
[MI.].

John W. Vinson[MVP]

 

[John Vinson]

Just figured out what you may have meant. Went back to the table and found
the field was entered as MiddleName. The form was labeled MI for that field.

<g> Yep. Stupid literal-minded computer... we all need the 2024 model
with the DWIM (Do What I Mean) option!

John W. Vinson[MVP]