Recent content by cawash

Hi Tess, I tried it again this morning and I'm still going to the form instead of a specific record. No matter which artist I select, I go to the first record of the form. Do you think there is a simpler way to this than what we're trying? Thanks again CW

I think I'm going to start over.... I'm really confussed now! I'll give you the info I have so far. The original form/SF is named frmArtistsID, and based on the query named 'qyArtistID' the new form that is used to select an artist is named 'frmSelect' and the combo box within the new form is...

[Artists Query]![cboArtistsID] 'Artists Query' is the Query name and 'ArtistsID' is the form/SF name

Tess, Thanks for the offer of Help, I may take you up on that. I created the query and based the form/SF to it and was able to add new records to the form. However, (the form with the Artist dropdown) when I select an Artist from the dropdown I go directely to the Artist form/SF rather than...

Tess I just thought of something else about your idea. You mentioned to base the original form/subform to the query. The original form/subform is used to input new Artist and their songs. If I base the original form to a query won't this keep me from adding any new data to the existing...

Hi Tess, thanks for the idea. I think I understand what your saying except for the "Go" button. I'm not good at coding so I will need help in this area. I've made a new form with a dropdown based off the Artist query. As the user selects the Artist from the dropdown, it will go to that...

i have a query that gives me artist's names. is it possible to click on a name from the query and it takes me to that particular name in a form. the form i have has artist's and a subform containing a list of the artist's songs. this is why i would like to have a hyperlink from the query for...

Thank you...that was exactly what I needed!

I have a field that lists an artist name; title of a song; ablum cover. i want to run a query when ran, it will give me only one listing of the artist. the query i have right now lists all 115 occurrances of the same artist. I just want each artist listed only once. thanks

Never mind........I found how easy it is to do what I was looking for. I have to admit...Sometimes I think some of the problems I have I make harder than what they really are. Thanks for being kind to beginners!

How do you add a hyperlink to a form that is not associated to a form? I'm making a simple db for my son's music. I want to be able to add the link www.cdnow.com to a form so he can find the music he wants. I don't want this link associated to any tables. TIA

thank you for the replies. what i was trying to do was change the appearance of the grey cmd button. this is why i decided to try a lable. what i did instead was to put a pic in the cmd button. thanks again

Is there a line of code that is needed to: when a user clicks on a lable a form opens. I'm not good at coding so help will be greatly appreciated!! cw