I have just added a control to a form called Status as a combo box with 4 items that could be selected, which pull down when the box dropdown is slected... But when i try to select one I get a ding and in the bottom left it says:
Control cannot be edited; its bound to a unknown field 'Status';
Now Status is a field in my database i can run querrys based on it with no problem.
I have also noticed that a few other controls have #Name? in the field when i pull up the form. I assume its for the same reason the status isnt working but I can figure out why its all going wrong.