I wasn't trying to steer you in one direction or another, just wanted to make sure that you and any other decision makers in your organization are aware that if you want to run a true Access web application you will need Microsoft Sharepoint with Access Services. Whether you already own/purchase and maintain that yourselves, or you pay a third party hosting service.
The second link provided, I've read over as well. Having someone on site setup citrix /terminal services is not an option. In my opinion, I do not believe it to be wise that everyone gets a copy of the FE database Again not everyone will have the ability to have MS ACCESS.
Just FYI, I think you misunderstood the explanation of Citrix/TS. In this case the client machines do not need to have Access installed. In post #7 of the actual thread that is referenced in that link, where Pat says this;
I don't do the technical work to set up Citrix or TS but I can tell you that the admin must be instructed to make sure each user gets his own copy of the FE.
that means that each user needs their own copy of the FE
within their defined workspace on the server. They would
not need Access or their own copy of the FE installed on their remote laptop or PC. Again, just FYI so you understand the options.
Moving on to your web form, like I said before it's going to require two macros to accomplish what you could do with a few simple lines of code before. I'll try to explain the process as best I can here, but I have also attached a small sample db so you can see this in action.
First, the data macro. To create or edit a data macro you need to have the table open, then go to Table Tools/Table and click the Named Macro drop down (like in the image below);
The logic behind the data macro that you need to create is that you need to create a parameter to store the value that you need in order to look up the appropriate record in the table. The value itself will be supplied by the second macro and in this case will be the Contract_No from the combo box on the form. Then, for each field value that you need to return from the record associated with that Contract_No, you will set a Return Variable (SetReturnVar). These return variables will supply those values to the second (embedded) macro in the form. One important thing to note here is that you need to make sure you set the return variables from
inside the
Look Up A Record In block The data macro would look like the following;
Next, at the form level, you create an embedded macro in the After Update event of the combo box;
This macro will run the data macro that you previously created (using the RunDataMacro action) and supply the parameter. You will then set the value of each unbound text box using the values that are supplied by the ReturnVars from the data macro. This macro would look like;
The attached sample db contains one table and one form with a combo box and three unbound text boxes.
