Recent content by jcstanley

I forgot to mention that the values change. so no matter what the value may be is it possible to automatically select value A?

Is there any code which will automatically 'click' the radio button for first option, which is in this case is OptionA. At present non of the radio buttons are selected and the user has to manually click their chosen option.

Hi I currently have a form which has 3 option values that change depending on the chosen value in a combo box using the following code: Me.Controls("OptionA").OptionValue = Me.PriceA Me.Controls("OptionB").OptionValue = Me.PriceB Me.Controls("OptionC").OptionValue = Me.PriceC If possible I...

Thanks for that. It works perfectly!!!!!! :) Thanks for all your suggestions

This does work in the sense that it opens the edit enquiry form for the specified customer but not for the sites. For example: If you are viewing CustomerID (2) and are viewing the second record in the site subform which would be (My Site 2), when the the EDIT button is clicked the EDIT Enquiry...

ok guys here is a sample version of my database thanks

It works!!!!!!!! :) Thanks for all your suggestions

Thanks for that. It works great with BackColor. Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer) Me.Section(acGroupHeader1).BackColor = Me.ColourNum End Sub The only thing is that you cant change BackColor to ForeColor. - There is no ForeColor option in the drop...

Hi I currently have a report based on a query which creates invoices for cutomers. What I would like to do is print each page of the report 3 times. - (Each page in the report contains details of different customers.) If possible can the text on each copy be a different colour? So the print...

Hi I have now changed it to stLinkCriteria = "[CustomerID]=" & Me![CustomerID] & " And [Address] = '" & Forms!Enquiry.Site.Form.txtAddress & "'" but still get the parameter value box for the address. The CustomerID is on the main form - (Enquiry). sooooo frustrating!!! thanks for your...

When opened directly it is fine. I can browse through the records and no boxes appear.

I have only changed the line stLinkCritera... etc. I replaced it with your code as follows: Private Sub Edit_Click() On Error GoTo Err_Edit_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "EDITEnquiry" stLinkCriteria = "[CustomerID]=" &...

Now instead of an error I get a Enter Parameter Value box asking for the address. If you type in the address it just goes to the first record in the site but it does choose the correct customerID.

Would it possible for you to show me where the quotes need to go as i am quite new to this. Thanks

Hi I have a form(Enquiry) which contains a subform(site) which are locked to prevent data being changed. When a button is clicked I would like to open the currently viewed customer's details and site details in another form called: EDITEnquiry which is not locked. I have managed to do this...