add remove buttons

[bakerboy_1111]

I was hoping someone out there could help me with creating an access form that can allocate cables to various cable drums.

Basically, I want to display two lists. The first is to display a list of cables that I have not yet added to a cable drum. The second list is to show a particular drum (and the cables allocated to it). I would like to create a menu such that when I select for example: drum no. 1, then this list will show all cables allocated to that drum.

Once I have this set up I hope to create two buttons, an add and remove button. Using these i wish to allocate cables to cable drums, simply by clicking the add button, and remove a cable from a drum by clicking the remove button.

I'm sure this is possible but i have no idea how to do it. I would be extremely grateful if someone could help me with this.

 

[Tiro Cupidus]

See how this works for you. =)

 

[bakerboy_1111]

Thankyou so much Tiro Cupidus,

That was exactly what I was trying to do!

I wish I knew more about Access, then maybe I could help you back sometime!!

Thanks again,

Bakerboy

 

[bakerboy_1111]

Sorry, just one more thing..............


How would I create a button that adds a new drum to the drum selection box?


Thanks

 

[Tiro Cupidus]

Something like

Private Sub btnNewDrum_Click()
   Dim varDrum, sql As String
   varDrum = InputBox("Drum:")
   sql = "INSERT INTO tblDrums (Drum) VALUES ('" & varDrum & "');"
   DoCmd.SetWarnings False
   DoCmd.RunSQL sql
   DoCmd.SetWarnings True
   Me.Refresh
End Sub

 

[bakerboy_1111]

Thanks again!!! : )