Hello everyone,
I'm having an issue with my database where a part of the script no longer seems to work after I split the database.
I used the manual split procedure:
* 1 empty database to become the Back end, import all tables
* 1 empty database to become the Front end, link to the Back end tables and import all but the tables
So far everything seems to be working, except 1 part.
The error I receive is captured in the attachment.
The relevant code is this:
The code is the "After Update" [Event Procedure] of a combo box.
This code works when the database is not split.
FYI
I'm not a VBA programmer, nor am I the creator/owner of the database, but I do have programming/IT background and I'm supposed to take care of the database now (that's the scary part) since the creators are no longer available.
Thanks for your help and feedback.
I'm having an issue with my database where a part of the script no longer seems to work after I split the database.
I used the manual split procedure:
* 1 empty database to become the Back end, import all tables
* 1 empty database to become the Front end, link to the Back end tables and import all but the tables
So far everything seems to be working, except 1 part.
The error I receive is captured in the attachment.
The relevant code is this:
Code:
Private Sub brandbox_AfterUpdate()
modelbox.RowSource = "select distinct tbl_devices.id, tbl_devices.model from tbl_devices, tbl_packs, tbl_portfolio_mobile where tbl_devices.id = tbl_portfolio_mobile.id and tbl_devices.id = tbl_packs.id and tbl_devices.brand = '" & brandbox & "'" & " order by tbl_devices.model "
packbox.RowSource = ""
packbox.Value = ""
modelbox.Requery
packbox.Requery
End Sub
The code is the "After Update" [Event Procedure] of a combo box.
This code works when the database is not split.
FYI
I'm not a VBA programmer, nor am I the creator/owner of the database, but I do have programming/IT background and I'm supposed to take care of the database now (that's the scary part) since the creators are no longer available.
Thanks for your help and feedback.
Attachments
Last edited: