Hi all,
Really need some help. I've got a relational DB setup although getting the forms to work is proving rather difficult.
I have one form that has a combo box on it. The values for this come from a table. What the user needs to be able to do is to add values to the table and then have the combo box dynamically refreshed so that they can then select the values they've added to it. So what I've done is put a button on the form that opens another form allowing them to amend the data. However, once they've added data and return to the orignal from the combo box is not updated.
What I have used is a trigger on an update of the 2nd forms text box to requery the combo box on the other form like such:
Private Sub TextX_AfterUpdate()
Forms!frm_Items.Form!Location_Name.Requery
End Sub
Where the original form is called frm_Items and the combo box is called Location_Name.
Problem is that it doesnt work. What I need to know (as I started trying to do this 5 months ago and now know why I gave up) is how to reference an item on a different form and get it to refresh. Or any ideas for a workaround.
Please help
Really need some help. I've got a relational DB setup although getting the forms to work is proving rather difficult.
I have one form that has a combo box on it. The values for this come from a table. What the user needs to be able to do is to add values to the table and then have the combo box dynamically refreshed so that they can then select the values they've added to it. So what I've done is put a button on the form that opens another form allowing them to amend the data. However, once they've added data and return to the orignal from the combo box is not updated.
What I have used is a trigger on an update of the 2nd forms text box to requery the combo box on the other form like such:
Private Sub TextX_AfterUpdate()
Forms!frm_Items.Form!Location_Name.Requery
End Sub
Where the original form is called frm_Items and the combo box is called Location_Name.
Problem is that it doesnt work. What I need to know (as I started trying to do this 5 months ago and now know why I gave up) is how to reference an item on a different form and get it to refresh. Or any ideas for a workaround.
Please help