Hello Richard For my music database I've got a band/artists table. I have a form to choose a band and a featuring artis. In the table I see de bandID number that's oke. But I can'r get the band names in text in my other forms and reports. How do I do that? Kind regards André Prins Bloemendaal Netherlands
Donald Blackwell
@Reply 43 minutes ago
If you want to be able to select the band in the table, watch Richard's Relational Combo video to see how to make it work. Or you can use vba or a macro to lookup a value to show in a text box with DLookup
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.