Microsoft Access Control can't be edited: it's bound to unknown field "unitofissue"

I added two new fields to a table.  I placed two combo boxes on a form and when I try to enter data into them I get the error "Control can't be edited: it's bound to unknown field "unitofissue"  or Control can't be edited: it's bound to unknown field "medicalmeasurement"

Both fields are listed in the "add existing fields" and the record source has them both.


SELECT MedicalMedications.MedicalMedicationsID, MedicalMedications.SoftSlip, MedicalMedications.ProcedureDate, MedicalMedications.ProcedureEndDate, MedicalMedications.MedicationsID, MedicalMedications.Dosage, MedicalMedications.DailyQty, MedicalMedications.UnitofIssue, MedicalMedications.MedicalReason, MedicalMedications.MedicalMeasurement, MedicalMedications.Location, MedicalMedications.VetStaff, MedicalMedications.MedicalNotes, MedicalMedications.Expiration, MedicalMedications.Manuafacturer, MedicalMedications.SerialNumber, MedicalMedications.Type, MedicalMedications.Type, MedicalMedications.TagNumber, MedicalMedications.UnitCost, MedicalMedications.spcaaccept, MedicalMedications.spcadecline, MedicalMedications.QtyIssued, MedicalMedications.MedsFollowup, MedicalMedications.MedsFollowupDate, MedicalMedications.VCAInvoice, MedicalMedications.VCAInvoiceApproved, MedicalMedications.DeliveryRoute, MedicalMedications.Measurement, MedicalMedications.MedicalCondition FROM MedicalMedications;

I've added many combo boxes to many of the forms in the database and have never had this error.

What is wrong?
J.R. SitmanIT DirectorAsked:
Who is Participating?
 
J.R. SitmanConnect With a Mentor IT DirectorAuthor Commented:
I got some help from John Vinson.  The problem was with the properties of the TAG.  I changed them to the name of the query and it fixed the problem.

Thanks for helping.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
In the table design view, are "UnitofIssue" and "MedicalMeasurements" setup with something other than "Textbox" in the Lookup section? If so, you can get this sort of issue.

To check, open the MedicalMedications in Design view, and select on of your columns. Then select the "Lookup" tab below the field grid - is that set to something other than "Textbox"?
0
 
J.R. SitmanIT DirectorAuthor Commented:
They are set to Text box
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Dale FyeCommented:
What version of Access are you using?

You indicate that both fields are listed in the "add existing fields" dialog box.  Which implies that they have not been properly bound to the forms recordsource.

try deleting those two combo boxes from you form and dragging the fields from the "add existing" dialog box onto your form.  You will, of course have to then change the control types from textbox to combo box and configure the row source for each of those controls again.
0
 
Dale FyeCommented:
"properties of the TAG"

not familiar with that acronym.  I know you're not talking about the Tag property of the form or of the controls.  Can you provide more detail?
0
 
J.R. SitmanIT DirectorAuthor Commented:
When I select combo box, then other tab, then tag
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You accepted solution makes no sense, and could not possibly be the solution.

Can you provide more details as to exactly how modifying the Tag property of your combo resolved this? What did you do with the Tag property, for example, and how would that possibly tie into the issue you reported.

The goal here on EE is to only save solutions in the PAQ that are valid and verified solutions. Unless you can provide more details you really should just Delete this question instead of accepting your comment.
0
 
J.R. SitmanIT DirectorAuthor Commented:
found my own solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.