Windows 7 64bit 
Access 2010 64bit
I have a form set up to enter product info, part number, pricing, etc. and a subform that links the data to another table for which models the parts go to. (this is automotive, so basically on the main form it says part number X is blah-blah-blah and costs Y. The subform then says "and it fits these cars" with a date range and make/model. Keep in mind these are cascading combo boxes in a subform... The problem I am having is that once I select the correct date range, make and model (which model is filtered to only show models by the selected make: so Ford only shows Mustang, Focus, Escort, etc. and Chevrolet shows Camaro, Corvette, etc.). So for this particular part number, I select its available for 1985-1990 Ford Mustang, then I go down to the next record, select the date range and make, but when I select the model, the model field on the previous record becomes blank... The data is still stored in the table and when I click on it again (or check the table) the selection is still there... The only thing I can think of is that I am pulling 2 columns in the Row Source (The autonumbered ID field and the field with the Model Name) and I have the column width set to 0"; which hides the first column (the autonumber)--which the combo box is bound to. If I unhide this and change "Limit to List" to "NO", then it shows ALL of the selected data on ALL rows, however it only shows the autonumber and not the model name... any suggestions??
Reply With Quote
