Search results

already tried that boblarson, it doesn't work at all. (see my previous post)

So I have tried putting a button in the purchase and sale forms which simply runs a requery on the combo box, and that works. After I add some new equipment, if I press the button, the combo box will then be updated. So I definately have to requery the combo box, the only problem is when. So it...

Yeah I have done it now. Ended up just setting each of the elements in the macro manually. It took a bit longer than I would have liked, and is probably a lot less efficient, but oh well. Yeah I probably should learn VB, but I am still resisting. I am just so used to C++ I guess, that coding in...

But if I do that, then it will give me an error message if I close the Add Equipment form and the sale or purchase form is not open.

Ok, basically I have an equipment table, a sale table, and a purchase table. Each piece of equipment can have a sale and a purchase. So when I go into the "Add Sale" or "Add Purchase" forms, there is a combo box so you can select which piece of equipment the sale/purchase refers to. The thing...

Hmm OK. I'll give that a try, although I prefer to stick to macros... When entering a macro, and I have Action: SetValue, it has Item and Expression. Can I tell it to set multiple items in the one line? like this: Item: [field1].[visible] AND [field2].[visible] Expression: Yes I tried using...

Hey guys, got a question about a form I am working on. Basically, on my form, the entire bottom half is only relevant for some records. So at the top I have a check box the user can click to say whether they only need the basic text boxes up the top to enter data, or whether they also need the...

Thanks missinglinq! I put the macro in the On Current update for the form and it worked perfectly. Thats exactly what I needed. Thanks for the help.

Tim, I tried making it text box instead of a label and giving it an IIf statement in the control source like you suggested, but it didn't work. I put: =IIf([bool+TAX?]="Yes","+TAX","") and when I ran the form nothing appears in the text box at all. Yeah I suppose I could give that a try...

I have some problems with form updates, and I need to know where to run the macros to make sure everything is up to date. So for example, at the moment I have a price in a text box and the words "+Tax" in a label next to it. Above this I have a tick box to toggle this (some sale prices include...

Hey everyone. I am making a simple database for my work, and I could use a little help with the forms. I did do a bit of databases back at university but am pretty rusty. Anyway, I am setting up an entry form to add a new entry to a table called "Rigs". Each rig in the table has an auto-number...