MI problem

F

faxylady

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.
 
J

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.'"
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]
 
F

faxylady

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...
 
F

faxylady

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...
 
J

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.
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]
 
Top