insert another field again into same form from another issue but not same issue

[Stephanie53]

[rpeare]

Well, there's one big problem if what you've shown is accurate. the choices in the combo box should be limited to the items in your PRODUCTS, *what* a client orders has nothing to do with what they *currently* have ordered. Change the combo box ROW SOURCE to a query that only shows data from your products (productID, ProductName, ProductCode)

Your query has a bunch of null values in the product code because of the way you've constructed it so it's likely showing the 'correct' value which is null.

I'm assuming your PRODUCTS table has a PK (autonumber) a product name and a product code, if that's the case you want your unbound control on your form to be =comboboxname.column(2) and the widths can be 0,1,0 so you never see the product code when choosing an item to fill an order.

[Stephanie53]

i wish that you had Access 10 to help me out..now i am stuck..is there anyone that can review my DB and help me out to be sure that i am even posting the correct things that is being requested??

becasue to be honest..I DONT KNOW IF THT IS ACCURATE! ...i am so frustrated and about to thro in the towel!

I GIVE up!

[Stephanie53]

i am marking this thread as solved and see if i can find another site where there is more people that have access 10 to be able to see what i doing wrong..please do not take offense of this but i need someone that can help me by doing exactly that..

thank you for your time on this

Stephanie

[rpeare]

You weren't providing the correct information, nor had you done what I suggested. Enclosed is the copy of your database that you originally posted with a correctly functioning product code. Just be aware that you do NOT need to store the product code, if you are storing the product ID you can retrieve the code for any form, report, query etc.


Database54.zip

I only changed 2 things.

1. Look at the difference in the ROW SOURCE for the combo box that stores the detail ID
2. Look at the PRODUCT CODE CONTROL SOURCE, it's no longer a value from your table, it doesn't need to be if you are storing the productID

[Stephanie53]

I thought you couldnt open this up?

I thought i did do all this..i am looking at other DB as i saved the one you sent as DB54b..

Thank you for your assistance in this and helping me out

Stephanie

[June7]

I made all the edits described in my post #8 and the form works. The Product Code automatically displays in the textbox. However, I did not try to make code work to save the Product Code because that is not necessary.

[rpeare]

I can't open 2010 files, I had to run all over creation to find someone that has a copy :P