Recent content by mdpepper1

If I am looking at an existing record in form view and alter some information, then change the view to design view, the record is updated with the changes. Why is this? How can I stop this update on view change? I have investigated the 'on view change' event and have not found anything...

Ive created a form using vba and I have used the createControl function to add a button to the form. I want to include code in the button creation which specifies what I would like to happen when the button is pressed (run an sql insert ) How can I achieve this? button code: Set...

Ok, I have fixed my table structure. I am now having trouble with populating my form. I want to add a species, then have a list of check boxes of the existing pieces of legislation in the legislation table. Is this the process I should undertake: 1. create form 2. add facility to add...

Thank you for your reply. I have researched this since I have posted and I absolutely concur. I am still in the process of learning about how to tie this whole database thing together and this is one of the most important lessons I have learnt. Again, thanks for taking the time to get back to...

I am an IT placement student working for a wildlife charity for one year. I have a table of 20 species. Each row contains some information on a single species. I want to add functionality to add a new species. That is easy. I have another table which is for the legislations that apply to each...