MI problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.'"
Click to expand...

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]
 
Thanks for your prompt reply. Please explain what you mean by "but set the
Control Source of your form textbox to [MI.]."

John Vinson said:
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.'"
Click to expand...

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]
Click to expand...
 
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.

John Vinson said:
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.'"
Click to expand...

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]
Click to expand...
 
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.
Click to expand...

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

John W. Vinson[MVP]
 
Back
Top