Access NOOB

[mandes]

Hi all

I'm trying to put together my first app in access, (I'm a PHP/SQL programmer), but I'm having trouble.

Im basically doing a CD library for a friend who runs a dance class, linking dances to songs but I'm stuck at the first hurdle of getting the the CD's to work, I have the follow form called CDs

cd_t.CD_Title
cd_t.Library_Ref
--Subform--
--tracks_t.Track_No
--tracks_t.Track_Title
--tracks_t.Track_Artist

CD_Title is displayed in a combobox populated with the album titles from the database.

I can flick backwards and forwards using the standard control panel on the bottom no problem, but want the whole form to be requeried on change of the combobox, I've tried everything I can think of but cant get it to work. ie I want to select the database record from the list of CD titles.

My DB relationship for these two tables is cd_t.cd_ID -- tracks_t.cd_ID

Ive tried putting Form_CDs.Requery in the combo after update, but all that does is alter my database data, why??

Thanks for your help

 

[boblarson]

Your CD_Title combo box needs to be an UNBOUND combo box. If it is bound, then it just saves whatever you change it to into the current record.

 

[mandes]

Bob

Thanks for the quick reply, I'll give it a go, I never even knew BOUND existed my medium is webapps, so doing everthing locally is a whole new ball game

Thanks again