C
capnelectron
I'm trying to copy a form from one access database to another. When
copied to the new database, I've changed the form's record source
property to a select query and everything seems proper (the field list
shows the proper fields from the query) but I can't reference any of
the fields in VBA code. For example, one of the fields returned from
the query is rating_id. If I try to reference it in the form load
event I get an error (method or data member not found).
i.e. Me.lstFind = Me.rating_id. The rating_id field does not show up
in the tool tip list after I type the Me.
If I create a new form, with the same record source query, I have no
errors with the same VBA code and everything works as it should.
I've commented all other event code in the copied form (to see if that
was causing the problem) but still no dice. Are there some database or
form properties that would limit the scope of fields from an underlying
recordset? I suppose I can painstakingly copy all the objects from the
old form to a new form, but I'm hoping for a simpler explanation (I
have many forms I would like to copy)!
copied to the new database, I've changed the form's record source
property to a select query and everything seems proper (the field list
shows the proper fields from the query) but I can't reference any of
the fields in VBA code. For example, one of the fields returned from
the query is rating_id. If I try to reference it in the form load
event I get an error (method or data member not found).
i.e. Me.lstFind = Me.rating_id. The rating_id field does not show up
in the tool tip list after I type the Me.
If I create a new form, with the same record source query, I have no
errors with the same VBA code and everything works as it should.
I've commented all other event code in the copied form (to see if that
was causing the problem) but still no dice. Are there some database or
form properties that would limit the scope of fields from an underlying
recordset? I suppose I can painstakingly copy all the objects from the
old form to a new form, but I'm hoping for a simpler explanation (I
have many forms I would like to copy)!