Search results

hmm still not having much luck. Any one know of something really simple i can read to help? All suggestions appretiated

Query Yes ive been trying to base it on a query but without luck. I keep getting an error that the query does not have access to the data. This is annoying as i need it desperately to display the payment method. All the forms do have the sale ID on them. All the forms are also based on querys...

Hello everyone! Having problems creating an invoice. All i want to do is print one from a form/subform and another payment form. from the payment form. How do i go about it? It needs to print a current sale. Any Clues? Thanks Chris

Haha done it! Reversed the forms (put the button on the main form) and reversed the code. all working fine now! Thanks!

HI again. Yes thats what i thought, from what ive gathered (as im teaching myself) it should be easier. But sorry still no joy same message "cannot assign a value to this field". Any ideas? Thanks for your help Chris

Hi, Ive tried that code unfortunately i get "cannot assign a value to this field". Ive attempted to do a query but unfortunately ive never done an update query so not any luck there. Both the form and subform are based on queries. Does this matter?

Hello people. Needing some help with a problem. Im using Access 2007 and having a problem with a sales form. For some background ive just set up a business on my own and wish to make my own sales/inventory/reports system. My actual problem is on my main Sales form. It is a form with subform...