MS access form combo box row source based on current field value

2
votes

Newb in Access (version I used: 2010) and VB. :(

I have a form and a table both named "issues", a combo box named "statusfield" (value list: open, reopen, wip, closed).

The form loads the content of table "issues" per record. One can modify the field value of records.

The aim is to show the available value list based on the current status of an issue.

For example, if the current value of "statusfield" is empty, when one clicks the combo box, available status would be "open;reopen;wip", and if the current value of "statusfield" is "open", then available status would be "wip;closed".

Could one explain as detailed as possible please? Appreciate it!

2
ms-accessvbams-access-2010

2 Answers

3
votes

Add this code in the AfterUpdate event of the combobox

If Me.statusfield.value = "open" Then
   Me.statusfield.RowSource = "wip ; closed"
End If
0
votes

So I redesigned the database, created the one to many mapping in (Database tools -> Relationship), with the same vba, everything works as designed. Cheers!