Form lookup with event attached (based on value)

  • Thread starter Thread starter Carrena
  • Start date Start date
C

Carrena

I'm new to access and haven't gotten to know programming code yet. I'm just
learning how to build a database with access tools.

I've built a .accdb database (for our Real Estate investment company) that
allows a non-access person to navigate the database using forms.

My problem: I have a form with a lookup.. listing status of a property
(Schudule Repairs, Repairing, Listed, Sale Pending, Hold, Closed). I would
like an
event that when "Closed" is selected, moves the tab to a field that asks for
"Closed Date". The macro I build is condtional with a "goToControl" action.
I get a error message; "...the component doesn't make the property or method
available for Automation operations.."

What does this error message mean? Any suggestions on how to build this
event are greatly appreciated!! Please help!!
 
One thing to be aware of is that you can't set focus to a field.
You have to set focus to the control (text box, combo box, etc.)
If the name of the control is different than the field name, you'll
need to make sure that you use the control name.
 
What actions should I have to make this work?
I have my conditional statement, followed by "GoToControl" action.
What am I forgetting?
 
Back
Top