Search results

I have a combobox, which has many columns, and depending on what value I select in this combo it brings up relevant information in other txtboxes. How do I get the first value to appear in the combobox, and have its related txtboxes already filled with the related information? Basically...

Using a button on a form, I use the following code to dictate what records appear in the report, basically whatever records are on the form. DoCmd.OpenReport "renewalreport", acViewPreview, , "[Renewal]=Forms![Renewalform]![Renewal]" My problem is that the form is a continuous form and...

I am trying to program access to keep a form1 invisible, while form2 is open. What sort of code should I use to state: Dim isopen as String isopen = "form2" If isopen is open then Forms![form1].Visible = False Else Forms![form1].visible = True End If Can someone help me finish off this code...

I have a combobox which has multiple values repeated, how can I limit the list to show only one value, and no duplicates?? Thnx for any suggestions,

I have a combo box which contains duplicates of certain values. How can I filter the combo box so that only one value is shown? Thnx for any help or suggestions

I have searched this forum for previous posts, and the microsoft support site but have been unable to find anything about making a form invisible. The reason behind this, is that I have a form which has a series of command buttons that leads user onto other forms. When selecting a form I wish...

Hello everyone, Does anyone know how to make a combo box un-editable so that users can't edit the data. But can still make a selection?? Any suggestions would be appreciated. Thanks, [This message has been edited by Irie (edited 07-31-2001).]

I have a continuous form based on a parameter query. The user enters the criteria, and then the records that match the criteria are displayed in the continuous form. My problem is if the there are no records found, how do I get a msg box to say "No records found"? I have tried various...