I am developing an Access application. I read data from a sql server table and populate an access table which is used as the data source for a combo box. After the application runs some of the retrieval process, the new data is in the Access table, but is not reflected in the combo box which just has values like #DELETED. I'm pretty sure the combo box just needs to be re-queried with a statement like this:
The combo box is not on the same form as the one that needs to run this query and I get an error that says object error 424 Object needed. I think I need to use a fully qualified reference to the combo box. How? I don't see any name property for the form, I don't know what the form is named. It does have a label (which has a blank in it), and I have tried something like this:
Which do not work. Do forms have a name property? How can I find it (if it does)? How to I reference this combo box from a form that is not it's container?