Search results

I have created the following formula in the Control Source field of a text box using the Expression Builder: = IIF([GRT]<= 500, "333,000")IIF([GRT]>500,333000+(2500*500)+ (([GRT]-3000)*333)) What I am trying to say is that if the field [GRT]'s value is between 1-500 then the default value is...

That's great thank you. If say I wanted to add another text entry in the TYPE field how is that done? So if Workboat and Crewboat is entered. Thanks

Thanks Colin, I put it in the oncurrent function and it worked. What I would like to do now is add another text box to the rule. The text box is called barrel capacity. I have written the following code but is not liked! Private Sub Form_Current() If Me![Type] = "Workboat" Then...

I have created a form in order to add data to an existing form. It has the same fields. It is just formatted slightly differently to make data entry easier. So ideally on the existing form I push a button saying "add new company", it opens up the new form with blank fields, data is then entered...

Thanks for doing that. I have posted your expression but it still doesn't work. I have looked at anything obvious but cannot see what it could be. Perhaps you may have some suggestions?

I am trying to run a IF, THEN expression. What I have created is : Private Sub Form_Open(Cancel As Integer) If Me!Type = "Workboat" Then Me!DWT.Visible = False End This works fine but where the TYPE field is enetred as another category other than workboat, the DWT field is still missing. Am...

I have a sub-form in a form that displays data that relates to the data in the single form. What I would like to do is double click on that record in the form which then opens a form that displays more of same data in the sub-form. I have created the double click action that opens a form, but...