Recent content by Sean_Sean

Yeah it has thanks

What should the queries contain?

Any other help? The above doesn't seem to work.

Well as of yet i have not tried anything as i do not know how to do it. Basically i've want the 5 forms all reading different information from the same table, is there a way i can just filter out some of the information for each of the forms?

sorry you mis-understood: The drop-down arrow contains a hidden column, in one text box (called totadults) i want to end up with a price by multiplying another text box by the hidden colomn of the drop-down arrow.

What does the "someotherfield" refer to?

I have got 5 forms all useing the same table but want different parts of information they are divided by 1 field for example: one form takes all the No.1s form the field whereas another takes all the No.2s form it is there any way i can filter it so they only contain the information they are...

I have 2 combo-boxes, first the user must select a value out of the first one and the something out of the second one. In the second one i want the price to be there but so the user cannot see it so that when they select something they are also selecting the price colomn that i can use a text...

I have got two drop-down arrows and on the 2nd one i would like it contain a field that the user did not see that i could then use to do a calculation. For example prices of a attraction's enterance fee is hidden in the drop-down arrow when the user enters how many adults and children there are...

no sorry, i now want the 2nd combo-box to take the user to a new form that will display the informaiton.

i have got 2 drop-down arrows allowing the user to first select a field that will then filter out the results in the second drop-down arrow. I would then like a function that would be able to take then to that record on a form. Is this possible?

My problem is quite hard to explain but here goes: I have got two combo-boxes on a form both linked to each other, the second one is the one i want to use. Basically the user selects a field out of the first box which them filters the results in the other box. I then want the user to be able to...

I would like to know how i can assign a macro to a button on a form that will take the user to another form based on the result in the combo-box. Eg: If the combo-box says: "Eden Project" it will take the user to that record on another form. Any ideas?

Please someone help on this matter, i've tried many different ways now to link combo-boxes so one is affected by the other but stll no luck. Read the previous 2 posts of mine and get back to me on what i'm doing wrong.

You replied to my message the other day about linking the combo-boxes, but after following your instructions: Right click on the second combo. Choose properties, then data. Goto the RowSource and hit the build button next to it. Start the query builder. On the grid make sure you put the fields...