Solved

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

Posted on 2014-03-14
8
3,149 Views
Last Modified: 2014-03-21
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?
0
Comment
Question by:J.R. Sitman
  • 4
  • 2
  • 2
8 Comments
 
LVL 84
ID: 39930142
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
 

Author Comment

by:J.R. Sitman
ID: 39930310
They are set to Text box
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39932398
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Accepted Solution

by:
J.R. Sitman earned 0 total points
ID: 39932553
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
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39932761
"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
 

Author Comment

by:J.R. Sitman
ID: 39932763
When I select combo box, then other tab, then tag
0
 
LVL 84
ID: 39933042
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
 

Author Closing Comment

by:J.R. Sitman
ID: 39944775
found my own solution
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question