No problem, glad you got it working
Just as a pointer, I know from experience that Access can be very daunting particularly when you first start using it and that it is a very multi-learning environment (structure, naming conventions, relationships, SQL, VBA etc etc) but you would be well advised to start using Visual Basic for Applications (VBA) instead of macros. It's a powerful programming language that is far more flexible than macros, there's lots of things that aren't possible with macros and importantly you can trap and handle errors (amongst other things). You'll find lots of examples of VBA code both here at UA and on the web.
Good luck with your project....