Recent content by Dophia

Hello: I would like to open different forms, based on dates in an unbound combo box on a different form. So, open a form to specify dates and then click to open a form with that date range of records. It is called from the form that is to open. I currently used something I came across online...

Thanks for the reassurance that that was not possible. I finally found a "me.visible=false" value on opening the new form. Sophia

I think it was because the data was not saved on the main form. If anyone knows otherwise, please let me know. Thanks, Sophia

Hi Everyone: I am stumped by this issue. I have a form with a button to click . When that button is clicked, another information pop up form opens. But the original form closes and I don't understand why it is closing. I have the same type of form in other areas of the database that does...

Thanks for the advise. :) Sophia

I want to open a form with a button, to save space on the main form. There are too many subforms showing in the Page Tabs across the screen, with the subforms on the page tabs. I am just trying to make it visually better to look at. Sophia

Thanks again Duane. It is working now. Is there an easier way to have a button open a linked subform? It is so easy to have subform linked to a main form the traditional way by having both forms on screen. Sophia

Thank you Duane. That was the issue for the error. But now when the subform opens and I fill in the data, the [Pound_Sheet_No] does not transfer to the subform automatically. I thought that that code would do it? Sophia

Hello Everyone: I have a main form with many subforms placed on tabbed pages, all linked to the main form. I would like to change some the subforms to be opened by a button instead. But the problem is that some of the subforms have not yet been populated, so I will need to pass the main...

Hi Everyone: I need advice on a form and a field with a drop down list. I have a form where the user chooses a item from a drop down list. The list is based on a query which has two fields. One field is a "medication" and the second field is a check box named "disable". So, any item that...

Ok, I understand now. Or I could just name it "Customer copy", etc, right? Sophia

Thank you very much Duane! I had the table, but for some reason could not get the desired result . I changed =[Copy] & " copy" to just the [copy], since it would not work otherwise. I appreciate your help! Sophia

Hello Everyone: I have been searching, but cannot find an answer for this. How can I print one report, many times but with a different footer . Each footer would have a different word, such as "customer copy", "office copy", "admin copy", etc? Thank you, Sophia

Hi Andy: That's a good idea, since there is a PK in the table. But how would I go about using it? Sophia

Hi Duane: Thanks for the reply. •Are all of the records new? Yes •Are these done in a batch or one at a time? One at a time. Is there any field or fields that determine the order/sequence of the records? No. We just want to alternate the employee who looks after the record. The employees...