Search results

I don't understand what those people are talking about. It looks like the guy who asked the question gave up in the end. I just don't understand, this box was working yesterday, and now when I go to open it again, it's died. :s

My condition is the 'Taxable?' field, which is Yes/No. Isn't that correct? I tried your expression in my database, and Access brought up an error message that said something like 'Your expression has too many closing parenthesis', then I tried putting an opening one after the IIf {so it looked...

Thanks for telling me about the character conventions :) I've only just started using Access, I feel like I'm stumbling around in a pitch-black room. In the example you just gave me, there are two close brackets, but only one open bracket. Will that work? Thanks for your patience :P

The entire bracket is ([Taxable?],1.1,1) Then it adds some. Is there supposed to be a bracket around the entire lot?

I just checked it and retyped the expression, but it didn't work. The field when in 'view' says #Name, but when it's in 'design', it says the expression (which I'm pretty sure is correct!) Can you see anything wrong with it: =IIf([Taxable?],1.1,1)*[After Discount]

But it worked before I closed Access.

Ok, I closed my entire database just earlier, and when I opened it back up at looked at my 'Order' form, the 'After GST' field has turned into saying #Name? What does this mean? Why has this happened?

I thought there might be a way to make data entry for someone who doesn't know how to use Access.

Is it possible to create a macro that makes a field? If so, how does one achieve this?

Yeah, I started them both with the =, but only the 'After Discount' field brought up the exclamation mark, so I changed it back to how it was before, and that worked again. But changing the 'After GST' field how you told me fixed the original problem, so it all works now. Thanks :)

Never mind, the exclamation mark just wants to fight. I will just leave it alone :P

When I change the formula in the control source, a little exclamation mark comes up that says Invalid Control Property: Control Source. What does that mean? I just typed in the expression into the control source.

Thank you :)

Is that in the properties box?

How do you change a formula in a form?

Yep, it worked :) Thanks very much!

I've made an order form for my database based on the table 'Sales'. Four of the fields include: VIP? (Yes/No) After Discount (Currency Calculated) Taxable? (Yes/No) After GST (Currency Calculated) If the VIP box is checked, the After Discount field displays the Subtotal (another calculated...

Thanks for that solution! Is there any way to make the list box so that the user cannot actually select anything? :) :) :)

I will pm you my database. :)

rodmc: I don't want them to interact with each other, I just want an up-datable display of data gotten from one table to just be displayed in another table's form to assist the user filling out the form. bob fitz: I don't know what you mean :s