Solved

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

Posted on 2014-03-14
8
3,231 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
microsoft Accesss Basic Coding 44 106
Displaying images within Access Form 6 69
Conditional Format if Between Dates 9 39
Return Data From Website in Access 6 44
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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 …

739 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