Search results

That is very weird. can you send me an mde file and see if it works for me?

When I do that, it overwrites the first item in the list with whatever you selected. So if you click Cyan and change it, it changes Photo Magenta to Cyan on the table.

Help!!!! I have 2 forms that you select the ink you want and it shows the quantity in a textbox. In Access 2000 format it changes the table when you change the quantity, however once converted to Access 2003, it doesnt save the table data anymore. I have included the MDB of both versions and...

Thanks but nothing is linked to that. Just an old table

I have a form that you select the ink you want and it shows the quantity. In Access 2000 format it changes the table when you change the quantity, however once converted to Access 2003, it doesnt save the table data anymore. I have included the MDB and could really use some help. Any other...

Thanks that does make it faster. However I am still having a problem with table data being overwritten. If I have a list in my table that says black/brown/blue/yellow and I make a change to the quantites, it over writes the first entry with whatever combobox item I had selected. So if Blue...

I have a form with a drop down to select ink type. Then a textbox with the quantity in it. When I change the quantity, it changes the top combobox item to whatever was selected at the time of the change. IE: If Magenta is selected, and Cyan is the top item it will change the top item to Magenta...

I have a form with a drop down to select ink type. Then a textbox with the quantity in it. When I change the quantity, it changes the top combobox item to whatever was selected at the time of the change. IE: If Magenta is selected, and Cyan is the top item it will change the top item to Magenta...

Yeah Rain ,my commenting needs work lol. How do I unbound the listbox Paul?

I have a form that allows users to click on an item in a listbox and it brings them to the selected record in another form. However, everytime I close the form and open it, it changes the client name in the list to the client ID. List is set up like this Client ID | Client Name| Order Date...

Perhaps this is sounding too complicated. I have a form with a listbox and when I click on a different name, I want it to change a textbox to have the information from a different field in the same row. So if I click the name Mike the "date"(which is a field) in the textbox should change...

it is the client field from the client table

I know I read it. But it still isn't updating the textbox. I tried that method already.

I have tried lots of options. Its just getting it to update on the onclick function for the listbox. Thats the problem

Yes. Based on the date stored in the feild of the table. Same id number

I am trying to populate a textbox from a field in a table based on clicking on a item in a listbox. User clicks a name from the Client table in the client field, and the date that is stored in the orderDate in the same row. I want the text11 textbox to show that date.