Search results

Thanks Pat for your reply. I have master form and a continuous form which is a subform. The information (the "GROUP") has to be displayed in the subform. This information is returned as a result of the FD-VISIT-GROUP query based on the criteria to be equal with the VISIT ID of the master form...

Hi everyone! Sorry for my late response. What I did is to create a text box and in the Control Source I have put the following DLOOKUP function =DLookUp("GROUP","FD-VISIT-GROUP","[VISIT ID] = " & [Forms]![PATIENT TABLE]![Text112]) Also I have created a button which is displayed for each row and...

Thanks for your replies. I have used the DLookup function in the Control Source property of the textbox. It gives the correct result but only for the first row. The rest of the rows are empty. Can you please let me know how to solve this problem?

I have a subform in continuous form. I want to run a query in each row and display the result in a combo-box or in a text box. What I did is to create a combo-box and in the "ENTER" property I use the OPENQUERY statement. It returns the result on a pop-up window and then it is displayed in all...

Hi everybody. Glad to join you. I am dealing with MS ACCESS for the last 4 months.