Recent content by Muna

The row source for the combo-box is SELECT tbl_p.P_ID, [plast] & " , " & [pFirst] AS Expr1 FROM tbl_p ORDER BY [plast] & " , " & [pFirst]; If notinlist I would like to add the the new name, how should I write the INSERT Statement? Thanks,

is your sub-form continuous?

Thank you Paul for your quick response, unfortunately the name of the documents or groups are not as easy as my first example. A better example: IF Group = “Active” OR “NRS” THEN OPEN c:\publisher\Current_6-12-24.pub IF Group = “Inactive” OR “TRS” THEN OPEN c:\publisher\Contact_3.pub IF...

The code below allows me to open a publisher document that is already merged to the current record. What I need is to allow the user to open the document according to the group they are reviewing. Any idea how to accomplish this? For example: IF Group = “A1” OR “B1”...

I can't make any changes unfortunately. The tables were created years ago and I was only asked to add the physician table and form. CurrentProject.All Forms solve the problem. Thanks,

Greeting, I new to this form and to access and hope to find an answer to my problem. I have 3 tables and 3 forms Table 1 - Form 1 --- Psych Patients Table 2 - Form 2 --- Med patients. Table 3 - Form 3 --- Primary Doctors. Each form has a combo box with a list of Primary Doctors. If doctor is...