Search results

Marvelous! Thank you so much for your time and your help :) I definitely have to make myself familiar with the order of events; thanks for the link. Regarding the Era table, a value list would indeed suffice for my purposes. However, when the database is finished, I'll post it on the web...

OK, I trimmed it. When opening the database, clicking on the locomotive picture takes you to the form with the Country combo box. As you can see, the UK flag is shown in both records even though 'BE' is selected in the second record. Thanks!

I'll try and make a slimmed down version tonight, which only contains the relevant tables, forms, fields, ... for this question.

I zipped it, but it's still 29 MB (there's pictures and manuals in it) and the forum limit for zip files seems to be 2 MB. :confused:

I wanted to send a link to the database that I've uploaded on Dropbox (db file exceeds the limit of the forum), but the forum doesn't allow me :( : To be able to post links or images your post count must be 10 or greater. You currently have 3 posts. Perhaps the following was a bit confusing...

Countries is not a lookup field. However, when looking in tblTrain, I noticed that, instead of the CountryCode, the ID is stored in the Countries field, so I guess the problem lies there ? How do I make cmbCountries store the CountryCode in the Countries field in tblTrain?

Thanks. When I try that, I get the following error: Compile error: Method or data member not found I guess I need to enter the Countrol Source for the image field? But what? Referring to 'Countries' in tblTrain gives the same error. :confused:

Hi there, This is my first post on the forum :) . I'm trying to create an access database to make an inventory of my model trains. I have a main entry form (frmTrain) where I enter all sorts of info regarding e.g. a locomotive. This info is then stored in a table (tblTrain). In the main entry...