Colin@Toyota
What's an Access?
- Local time
- Today, 14:08
- Joined
- May 2, 2006
- Messages
- 203
Hi all,
I've been searching for a couple hours, and I can't seem to find the answer to my problem on any number of forums. I will start by explaining it...
I have a combo box on an invoicing form that is populated by a select query that lists records of active projects (by project number - a user defined 5 digit number); whether a project is active or not is determined by a checkbox (a yes/no field in the table). Using the OnNotinlist event, I have it set up so that a project editting form is opened where the user can search by project number, and select "Active". The problem arises when going back to the first form, the combo box wont update. Properties for the combobox include that null values are unacceptable, because each invoice that a user inputs must be assigned to an active project.
I have found lots of examples about adding a record through the OnNotinlist event, but changing some data in an existing record seems to have stumped me.
Any help will be greatly appreciated! Thanks
I've been searching for a couple hours, and I can't seem to find the answer to my problem on any number of forums. I will start by explaining it...
I have a combo box on an invoicing form that is populated by a select query that lists records of active projects (by project number - a user defined 5 digit number); whether a project is active or not is determined by a checkbox (a yes/no field in the table). Using the OnNotinlist event, I have it set up so that a project editting form is opened where the user can search by project number, and select "Active". The problem arises when going back to the first form, the combo box wont update. Properties for the combobox include that null values are unacceptable, because each invoice that a user inputs must be assigned to an active project.
I have found lots of examples about adding a record through the OnNotinlist event, but changing some data in an existing record seems to have stumped me.
Any help will be greatly appreciated! Thanks