drrocket5292
Technical User
Hi,
I'm new to databases but I am making one for my work. I created a form in MS Access that has four listboxes on it and I have written code that allows me to delete records based on what is in one of the listboxes if I want to. One problem that I am having is that after I delete a record it wont let me click on any of the listboxes the next time I go to form because it says the record is deleted. The only way to get the form to work is to click the scroll button access provides on the bottom of the form to move to the last record. Is there a way to write code so that the form automatically goes to the last record every time the form opens and every time I delete a record? I am really new to writing VBA so the simpler the better. thanks in advanc for the help.
I'm new to databases but I am making one for my work. I created a form in MS Access that has four listboxes on it and I have written code that allows me to delete records based on what is in one of the listboxes if I want to. One problem that I am having is that after I delete a record it wont let me click on any of the listboxes the next time I go to form because it says the record is deleted. The only way to get the form to work is to click the scroll button access provides on the bottom of the form to move to the last record. Is there a way to write code so that the form automatically goes to the last record every time the form opens and every time I delete a record? I am really new to writing VBA so the simpler the better. thanks in advanc for the help.
