Error in forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created two tables. One table defines abbreviations and descriptions for DEFECT CODES (ex: C - Computer) and the other lists individual DEFECT OCCURENCES and the specific information. After doing some reading and playing, I was able to link the two tables together and make it so that when entering data in DEFECT OCCURENCES, the defect code was a pulldown list with the abbreviation and description (C - Computer). After getting this to work, I made a normal form through the wizard to speed-up the data entry. Now, though, whenever, I get to the defect code field on the form, a line appears at the bottom of the window saying, "control can't be edited; it's bound to unknown field 'Downtime Code'." Can anyone help me with this? I'm new to Access and struggling, but still trying to make use out of what I know to be a cool program

Thanks!
 
Rawley,

It seems your dropdown (a combo box, I take it) is bound to the wrong (or
non-existent) field in your table/query. Open your form in design view,
select the combo box and open the properties window. On tab Data, the top
property is Control Source; check the field name in it, and change if not
what it should be (use the drop-down within the property cell).

HTH,
Nikos

Rawley said:
I created two tables. One table defines abbreviations and descriptions
Click to expand...
for DEFECT CODES (ex: C - Computer) and the other lists individual DEFECT
OCCURENCES and the specific information. After doing some reading and
playing, I was able to link the two tables together and make it so that when
entering data in DEFECT OCCURENCES, the defect code was a pulldown list with
the abbreviation and description (C - Computer). After getting this to
work, I made a normal form through the wizard to speed-up the data entry.
Now, though, whenever, I get to the defect code field on the form, a line
appears at the bottom of the window saying, "control can't be edited; it's
bound to unknown field 'Downtime Code'." Can anyone help me with this? I'm
new to Access and struggling, but still trying to make use out of what I
know to be a cool program.
 
Back
Top