Helo all,
fairly simple problem but im the solution could be a problem! Anyways I ahve a form that displays a Computers Information such as: user, pc build etc..
On this for i also have a subform thats shows what software and licenses are attached to this system. Relationships are made through a junction table (tables of PK's, FK's etc) This information is displayed in a datasheet view.
baisically I want to create a button so that the user can select(highlight) a record off this subform and click a button so that this record is deleted.
Getting the record to delete is no problem I can write that query however I need to know whether in VBA u can select a line from a subform and independantly use each value from each column to delete the specific record in vba. If not then what is the best way to achieve this? I m talking from both a HCI (Human Computer Interfaces) and Access point of view!!
much appreciated
monkey o_0
fairly simple problem but im the solution could be a problem! Anyways I ahve a form that displays a Computers Information such as: user, pc build etc..
On this for i also have a subform thats shows what software and licenses are attached to this system. Relationships are made through a junction table (tables of PK's, FK's etc) This information is displayed in a datasheet view.
baisically I want to create a button so that the user can select(highlight) a record off this subform and click a button so that this record is deleted.
Getting the record to delete is no problem I can write that query however I need to know whether in VBA u can select a line from a subform and independantly use each value from each column to delete the specific record in vba. If not then what is the best way to achieve this? I m talking from both a HCI (Human Computer Interfaces) and Access point of view!!
much appreciated
monkey o_0
