Big pain in the A??????

[DaniBoy]

Hello,

I have been killing myself trying to make a simple invoice database. It only has four tables.... clients, products, invoice, invoice_details.... Well its been a while since I have used access and I wanted to make this simple database for my cousins small hardware store. All my relationships are fine all forms are great but the only thing that its driving me crazy is that when I create the invoice form with the invoice_details subform and make some little changes like convert to combo from text box ext, before on my 97office all I did was change the text boxes to combo select the product on the detail and I would get the price of the product, Now when I do it in office 2003, it does not work.....it always shows $0.00

So I converted a 97 file I had of a small database to 2003 and the invoice worked great, as soon as I deleted the forms and created newones the crap wont show the prices!!!!!...

Is this just me or is there something we have to trigger in office 2003 for this to work?!!!

 

[The_Doc_Man]

Sounds to me like maybe the old forms were using a little-appreciated function of combo boxes. You know, of course, that if you have a combo box that retrieves multiple fields, it doesn't have to show all that it found. You can say, "show me field 1" and still have field 2 associated with the selection. Then, if the form also has a control with the same name as field 2, that field automagically gets populated when you make the combo select.

Look up combo boxes in the help files to learn more about the hidden features thereof.

 

[DaniBoy]

Thanks Doc,

I figured it out, it was as simple as picking my nose!!!! hehehehe, its been a while since I used access and what seemed like nothing than meant a lot this time.... It was an event, afterupdate event.... Sorry for the waste of time!!!