Recent content by snoopy12

I tried to convert it again to 2003, but it won't allow it. i've attached another file, but it's from 2010. something about using updated features that won't allow it to save to an earlier version.

Okay, i figure i'll post it for some input while i also try to work on it. this is what i would like it to do sticking with the sales records form: when i choose an item from the 'product' drop down i would like it to auto-fill the following fields - product description, product id and GTIN...

the customer name/address is working fine. i have a customer form/table to store their information and it populates correctly when i enter a sales record. will try the couple of suggestions given for the product issues. if needed can i post the database to have someone look at it and offer...

okay, I think I'm following Bob's thought and will give that a try. In reference to Pat's post - i have a product table with a list of products and their corresponding UPC numbers and product numbers. when a customer places an order i'm using a sales table that would include the customer...

I am having form trouble. i have a drop down box that when a product is chosen a second field will populate with the corresponding product code. I would like that same drop down box to populate two other fields. the drop down is pulling data from a specific table that contains all the...

Thanks, you've been most helpful. Now i don't feel so discouraged that i couldn't figure out what was wrong.

Thank you for clarifying. I thought you had to have everything set in the tables before building the forms. As long as i understand - i can remove the drop down from the two fields in question from the tables, but keep my settings for text/numbers/etc. Then i can create the form and add the...

I'm setting all the requirements in the table before creating the form. Am i doing this backwards? The drop down is set to show two columns - name and account. I don't want to remember the accounts for each name and want the account to populate the field. I've attached the database for...

i can't get the lookup wizard/drop down list to work properly. i have two fields that need a drop down list. the first works - it shows two columns, name and account; and populates the field with the account. the second doesn't work - it shows two columns, name and item number; and populates...