Recent content by lucylyn

Sorry for not coming back, my customer has now said there might be another number I need to take into consideration which changes things. However the person with the answer is on holidays. I will have to put this on hold for now.

I will need a bit of time to get the database ready as it has lots of entries. I will get that done shortly. To answer your question The reason I have the Combo Box is that the 372 number ALREADY EXISTS in the database stored in the Customer Table. When a new order is being created we...

Thanks for your reply and the link to the video. This is something I did not know and is certainly useful, however I'm not sure it will help with this problem. I have a combo box for the 372 number which looks up the customer and fills in all the other boxes like name, category etc. Since...

Hi John Thank you. I hope I will learn a lot here. Lynda

I wonder if anyone can help. I don’t know VBA and only have managed with what I have found on this forum. My Database is related to cattle and samples being tested in a lab. In my order form I have a Combo Box that uses the Not in List Event to check if that Farmers (372 number) is in the...

Hi I am new to this forum, I have been viewing for some time but only joined in now. I have been using Access for a few years but do not know much about programming. I have found many helpful codes on this forum which I have used but would not be able to write them myself. Lynda