I’m having a problem working in a database that I did not build, so I am not entirely familiar with it. I have tables tblProperties and tblInspections. tblProperties has information regarding individual properties as well as contact information. tblInspections has information that’s been entered for individual property inspections. It also has fields populated based on the current property information, such as building owner and contact information.
tblProperties is the source for frmProperties and it is from this form that a new inspection is generated. In form design view of frmInspections, the field list has all of the fields as they are in the table, but when I go into VB, the object list for that form is different. For example, in the Form_Load event instead of just PROPCLASS, the list has hidPropClass as well as PROPCLASS. It is referenced in the code that Me.hidPopClass = rst!PROPCLASS, but I’ve added new fields and can’t figure out how to have them referenced this way.
I hope I’ve explained this okay…I’m very lost.
Carolla
tblProperties is the source for frmProperties and it is from this form that a new inspection is generated. In form design view of frmInspections, the field list has all of the fields as they are in the table, but when I go into VB, the object list for that form is different. For example, in the Form_Load event instead of just PROPCLASS, the list has hidPropClass as well as PROPCLASS. It is referenced in the code that Me.hidPopClass = rst!PROPCLASS, but I’ve added new fields and can’t figure out how to have them referenced this way.
I hope I’ve explained this okay…I’m very lost.
Carolla