Cascading Combo + New Record Help

[Abbos]

Afternoon,

I'm having a problem with a form used to display table records as well as create a new record entry.

The form has 2 combo boxes and the rest are fields.

Combo1: Artist
Combo2: Gallery

I would like it so that when the form opens and displays the first record it will also populate the two combo's with the correct details for that record. Secondly when I click to create a new record it will populate the first combo with all artists but then the second combo will populate with multiple galleries (I think because that artist might have done work with multiple galleries).

I'm a little stuck so any help would be great at this point!

 

[Abbos]

It's just been one of those days! Complete stupidity on my part.

Sorry

 

[BobJones]

How about right clicking on the combobox and then clicking on the Row Source box and clicking the button to the right of it. Then make a query so it selects artist from the artist table where the Artist.RecordID = Forms!FormThatItsDisplayingIn!RecordIDTextField