I have created a standard "three-tier" database design, following Visual Basic and using Access 2003. I have created a Data Services module, a Business Services module, and I have a form with unbound controls. I haven't gotten any error messages; however, I can't get the form's controls to populate with data. I suspect that I already have a handle on the problem...I can't seem to be able make a proper connection between the Data Services module and the Business Services module. In
VB, there exists a BindingCollection method that I could use to declare each recordset as a DataMember, but I find that Access 2003 doesn't have the equivalent. It has been suggested that I create each recordset that I want to use in my Data Services module as a Property and expose them to the Business Services module (and the form's unbound controls) that way. Surely, there must be a better way to create the flexibility that I want here. Any suggestions, or am I going in the wrong direction? Thanks.