Search results

yes i can do that, but what i want is to use an input box so that i can enter a price, and it will update the prices using what i enter. if i do as you say, it will just search for people with that surname, i want to be able to enter a price, then it take the price and use it as the updateto...

Hello, i was wondering if you could help. I want to run an update query, taht updates prices in a table. But i would like to be able to choose the criteria when the query runs, for example a message box appears, that will allow me to enter a certain amount for the prices to change by. Could...

ok, but i am not able to get it into single view when i am looking at it in the main form with subform. when i open it up all i can see is datasheet view. how do i select form view/single view?

they are all set to visible yes in the properties

ok done it again and still not worked. i have attached screenshots of the design view and the form view, so you can see what i ahve done to the subform

yes i tried to create a footer, but it will not display when i load up the form. its hidden for some reason. i will give it another go and post up my results with some screens. cheers

ok thankyou. could you do me a favour and try to explain something for me. i have had a look on the Northwind 2007 sample database. On the Order Details form they have got a subform, much like mine. Except they have got a totals section at the bottom. how would i go about doing this? thankyou, i...

Hello, i am new here, but have been doing access for a couple of months or so now. However i have got a problem, which seems like a very easy task when reading around and looking at samples, but i cant get it done. Ok, basically I have got a Main Form and a Subform. The main form display details...