I made a form for users to go back and see saved records as and when required. However my cascading combo box are not showing the saved information. Information is saved in back end.
I made a form for users to go back and see saved records as and when required. However my cascading combo box are not showing the saved information. Information is saved in back end.
Not enough info. Please tell us WHAT you are doing, and any related code you think may be important.
Did you requery your combos after having made an update?
Private Sub cboRootCause_AfterUpdate()
Me.cboMicroRootCause.Requery
Me.cboMicroRootCause = ""
End Sub
I used this code to requery
I have database in which I made a form in which I filter B based on A and C based on B.
and I designed the form so that people can go back to the records in form and see previously saved records. However my combo box information is not showing previously saved records in the combo box and comes as blank. However combo box info is saved in backend
You are resetting the Me.cboMicroRootCause = "" to an empty string (would seem empty/no value)
Try commenting that line and see what happens.
Doesn't make any change
As orange said, if the combobox is bound to field and you set the combobox to "" then you are replacing record data with empty string. I don't see how data was ever saved.
Are these comboboxes on Continuous or Datasheet form? Are these comboboxes multi-column with alias? That won't work on Continuous or Datasheet.
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.