Solved

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

Posted on 2014-03-14
8
3,301 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 85
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 48

Expert Comment

by:Dale Fye
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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe 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 48

Expert Comment

by:Dale Fye
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 85
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

630 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