Hi,
I created an Access database, which I use for storing musicians' details, engagements etc. I've removed all the sensitive information and attached it with this post. If anyone gets any time, would you mind checking it over for me please?
I have a few concerns in particular. They are:
When I use the version with all my data in, whenever I enter a new player using the F_Musicians form, it updates the MusiciansDetails table, but not the MusiciansDetails Query. However, with this test version is seems to be working fine. Do you have any idea why this is happening? Edit: As soon as I manually enter the number in the GeographicalArea field in the T_MusiciansDetails table, then the MusiciansDetails query updates. That's a little bit annoying, but at least I know the reason for it now.
With the F_Musicians form, on the first tab. the GeographicArea is displayed from a subform. It looks ugly though! All I want ideally is to look identical to the other boxes on the screen, but I don't know how to achieve this. Also, if I add a new player, it seems that I can't enter any data into it. Maybe a drop down list would be good.
Similarly, on the instruments tab, I can't change the data there.
On the MusiciansDetails Query, I can't add new data. Perhaps it's read only, and related to my first concern above?
I've probably got lot of other questions that I can't think of at the moment, but if anyone can offer any advice I'd be very grateful.
Thanks.