Solved

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

Posted on 2014-03-14
8
3,010 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:jrsitman
  • 4
  • 2
  • 2
8 Comments
 
LVL 84
Comment Utility
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:jrsitman
Comment Utility
They are set to Text box
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
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
 

Accepted Solution

by:
jrsitman earned 0 total points
Comment Utility
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
"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:jrsitman
Comment Utility
When I select combo box, then other tab, then tag
0
 
LVL 84
Comment Utility
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:jrsitman
Comment Utility
found my own solution
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

762 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now