jhoelesmejarda
Registered User.
- Local time
- Today, 11:42
- Joined
- Jan 10, 2013
- Messages
- 26
Good day,
I need help. I encountered an error with my form when I used a combo box to get the set of data that I need. the combo box is from the look up value from a table, then I made a main form and attached a subform which is made from a query, after I put them together the form looks great not until I switch to another supplier or click refresh to get the new data, one of my record is mixing to another supplier and when I checked the table where the data is recorded it was also change, so if I use this form and clicked on supplier1 the data is good, then switch to supplier2 and then click refresh or if I alt tabbed the data is there and its supplier is also changed. I tried to delete it and retyped it but still the error sticks, also I tried to delete it permanently but still one of the data is mixing on a different supplier and its supplier in the main table is also changed. please help me. if you need to see the file pm me with your email address I will send it to you. I really need some help thank you. btw I'm using access 2007 and also a friend of mine tested it in access 2010 but the output is different it reflects the correct data.
I need help. I encountered an error with my form when I used a combo box to get the set of data that I need. the combo box is from the look up value from a table, then I made a main form and attached a subform which is made from a query, after I put them together the form looks great not until I switch to another supplier or click refresh to get the new data, one of my record is mixing to another supplier and when I checked the table where the data is recorded it was also change, so if I use this form and clicked on supplier1 the data is good, then switch to supplier2 and then click refresh or if I alt tabbed the data is there and its supplier is also changed. I tried to delete it and retyped it but still the error sticks, also I tried to delete it permanently but still one of the data is mixing on a different supplier and its supplier in the main table is also changed. please help me. if you need to see the file pm me with your email address I will send it to you. I really need some help thank you. btw I'm using access 2007 and also a friend of mine tested it in access 2010 but the output is different it reflects the correct data.
